How to calculate % of one row over another row?

Options
jimfeng5
jimfeng5
in Modeling

Hi guys,

I am trying to do the calculation of % of Show Specific / Total Universe and it's not giving me correct %. In the image below, the correct % should be 5401 / 21682 = 25%, but it's showing 4800%. Can someone please advise what I did wrong?

 

Capture.PNG

 

Thanks,

Jim

Tagged:

Best Answer

  • Tiffany.Rice
    Tiffany.Rice
    Answer ✓
    Options

    Hi @jimfeng5, by chance do you have the Summary type on set to "Sum"?  If so, what is displayed for total list items will be the aggregation of all elements within that list.   Likely you will want that setting set to "Formula". 

Answers

Categories