G
Guest
I have a report which calculates a running sum of a transaction quantity.
The report is constrained to specific dates. So the running sum starts with
the first transaction within those dates, which for example could be 4. If
the next transaction is 3, the running sum is 7, etc.
I want the running sum to start with the quantity before the report start
date. So if that number is 500 and the first transaction on the report is 4,
I want the running sum to equal 504 and continue from there. I have a
formula to get the start number. but cannot figure out how to start the
running sum with that number then continue with each transaction.
The report is constrained to specific dates. So the running sum starts with
the first transaction within those dates, which for example could be 4. If
the next transaction is 3, the running sum is 7, etc.
I want the running sum to start with the quantity before the report start
date. So if that number is 500 and the first transaction on the report is 4,
I want the running sum to equal 504 and continue from there. I have a
formula to get the start number. but cannot figure out how to start the
running sum with that number then continue with each transaction.