Running Total Problem

[Anonymous]

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.

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 !

[tresesco]

Try:

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

[Anonymous]

Thanks that worked.