How to work out the percentage of a row

Ajay Sonoo shared this question 3 years ago

Hi There,

I've created a table to work out the percentage between SUM noOfdDirectPriceCheaper and Sum noOfAppearinSearch using the following calculation using the Simple formula type: SUM ( noOfDirectPriceCheaper ) / SUM ( noOfAppearInSearch ) * 100.

However, the calculation is providing the results for the columns only, instead on a row-by-row basis (see file - percentage total is based on the sum of the two columns).

Can you advise on how to apply the calculation to each row, with the result showing under %BestPrice



Replies (0)

Leave a Comment
Attach a file