Good Day All,
I am having an issue with the below. Please see sample file.
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 !