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