Highlighted
Contributor

How to calculate % of one row over another row?

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

2 REPLIES 2
Highlighted
Certified Master Anaplanner

Re: How to calculate % of one row over another row?

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". 

Highlighted
Contributor

Re: How to calculate % of one row over another row?

Hi Tiffany,
Thank you so much, that's exactly what I'm looking for!
Jim