Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Running Total Problem

Good Day All,

I am having an issue with the below. Please see sample file.

Problem statement:

I have space in a warehouse for 1000 Pallets.  I need to subtract the amount of Pallets ordered from this grand total.  Meaning the end result should look like the below.

Capture.PNG

I believe the solution can be accomplished using either the above or rangesum functions but I have not been successful in my attempts.

Could anyone please suggest any solutions.  Whether it is frond-end or back end solutions.

Thanks in advance !

2 Replies
tresesco
MVP
MVP

Try:

1000-RangeSum(Above(TOTAL sum(Pallets),0,RowNo(TOTAL)))

Capture.JPG

Anonymous
Not applicable
Author

Thanks that worked.