start running sum with specific number

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
shanebgross said:
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.


SInce the first detail needs a different formula than the
other details, start be creating a text box named txtDetail
with the expression =1 and RunningSum set to Over Group.

Then your running transaction quantity text box can use an
expression like:
=IIf(txtDetail = 1, start number formula, 0) + quantity)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top