How to work out the percentage of a row

Ajay Sonoo shared this question ago

Answered

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

Thanks,

Ajay

Files:

The same question

How to work out the percentage of a row

Replies (0)