Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaymehtaece
Contributor
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

1 Solution

Accepted Solutions
sunny_talwar

How about if you try this

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

View solution in original post

1 Reply
sunny_talwar

How about if you try this

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

View solution in original post