I have the following report"
GH1 Customer
GH2 Document
Det Applied Documents (could be no details for a document)
Example of data
GH1 ABC Company
GH2 Inv1000 $1000
Det Pymnt200 (600)
Det Pymnt201 (250)
GH2 Inv 1001 $600
GH2 Inv 1002 $400
Det Pymnt202 (150)
What I Need is a new column for each record for the balance ie
$1000
$400
$150
$750
$1150
$1000
The balance is the first amount, then difference between next amount and previous amount etc.
GH1 Customer
GH2 Document
Det Applied Documents (could be no details for a document)
Example of data
GH1 ABC Company
GH2 Inv1000 $1000
Det Pymnt200 (600)
Det Pymnt201 (250)
GH2 Inv 1001 $600
GH2 Inv 1002 $400
Det Pymnt202 (150)
What I Need is a new column for each record for the balance ie
$1000
$400
$150
$750
$1150
$1000
The balance is the first amount, then difference between next amount and previous amount etc.