Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ajaymehtaece
New Contributor

Running Total not working

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.

Running total.PNG

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Running Total not working

How about if you try this

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

View solution in original post

1 Reply
Highlighted

Re: Running Total not working

How about if you try this

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

View solution in original post