Column calculations

[shamitshah]

Hi,

Please see attached.

I have two tables - Table A has the raw data and Table B has the same data except with Full Accumulation.

In Table B, Column(2)/Column(1)  does not come out with the right result.

Any idea on what the correct expression should be for Table B?

Thanks

Shamit

[sunny_talwar · Accepted solution]

Try this:

=num(RangeSum(Above(Sum(Margin), 0, RowNo()))/RangeSum(Above(Sum(Sales), 0, RowNo())))

[shamitshah]

Hi Sunny,

Many thanks.

Shamit