Range sum is not working properly

[ajaymehtaece]

Hi Team,

I am trying to calculate running total by using rangesum function
=Aggr(RangeSum(Above(TOTAL Sum([ABS Error EA (Shipment)]), 0,RowNo())), [Product Level Value])

But unfornately its not returning the correct values.

Please suggest the correct solution.

Thanks in Advance

[jyothish8807]

Hi,

Try this if it works:

RangeSum(Above(TOTAL Aggr(Sum([ABS Error EA (Shipment)]),[Product Level Value]), 0,RowNo()))

or just this:

RangeSum(Above(TOTAL Sum([ABS Error EA (Shipment)]), 0,RowNo()))

[ajaymehtaece]

Thanks for reply Jyothi,
But the formula suggested by you is not working for me.

[jyothish8807]

Will it be possible to share a sample data?