Discussion Board for collaboration on QlikView Scripting.
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.
How about if you try this
RangeSum(Above(TOTAL Sum([ABS Error EA (Shipment)]), 0, RowNo(TOTAL)))
View solution in original post