Forum Discussion

Chris_noob's avatar
Chris_noob
Frequent Visitor
2 years ago
Solved

Score calculation help, stuck with SUMIF equivalent in Excel

Hi Forum,   I'm working on a report to calculate scores and I'm a little bit stuck.   My report calculate scores with a weight factor. It's composed of 3 tables Cat, Question and Choices. I have...
Need Help
  • Chris_noob's avatar
    Chris_noob
    2 years ago

    Hi AllisonKennedy 

     

    Thank you very much for your help. I found an option, I added a Matrix, with the calculated columns and summerized using sum and it did the trick 😉

Chris_noob's avatar
Chris_noob
Frequent Visitor
2 years ago

Hi AllisonKennedy 

 

Thank you very much for your help. I found an option, I added a Matrix, with the calculated columns and summerized using sum and it did the trick 😉

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Chris_noob Apologies for not replying over the weekend. Glad you found a solution. Matrix subtotals are fantastic - it's very similar to Pivot Table in Excel if you're familiar with that. 

     

    As per your other question on why it wasn't working - the formulas I provided need to be created as MEASURES not COLUMNS. Not sure if that's what was causing the 0s?