How to calculate % of one row over another row?

jimfeng5

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?

 

 

Thanks,

Jim

Tiffany.Rice

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

jimfeng5

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