Running Total not working

[ajaymehtaece]

Hello everyone,

I am trying to calculate running total in the last column using formulae(Aggr(RangeSum (above(sum([ABS Error EA (Shipment)]),0,RowNo())),[Product Level Value])

But unfortunately its throwing some garbage value in few of the rows. Kindly suggest me the proper solution.I am trying from long time but not getting the solution.

Thanks in advance.

[sunny_talwar · Accepted solution]

How about if you try this

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