Need to refer to previous Data section line
Is there a way for a Data section record to refer to the previous Data section record?
I would like to calculate/show a running balance for the order records.
So, line 1 needs to realize it's the first line for this customer, and the order cost becomes the running balance.
Line 2 then needs to know the running balance on Line 1 and add it to the cost on Line 2 to become the running balance on Line 2.
And so on to the bottom record of this customer.
Is this possible? Thanks for your help.
I would like to calculate/show a running balance for the order records.
So, line 1 needs to realize it's the first line for this customer, and the order cost becomes the running balance.
Line 2 then needs to know the running balance on Line 1 and add it to the cost on Line 2 to become the running balance on Line 2.
And so on to the bottom record of this customer.
Is this possible? Thanks for your help.