Beginning A/R - Ending A/R calculation

[dean12]

So I have three values "CHGS", "PMTS", and date. I want to create a report that looks like this:


Date Beg. A/R CHGS PMTS End A/R
----- -------- ---- ---- -------
1/02 0 100 50 50
2/02 50 100 0 150
3/02 150 0 50 100
---- ---- -------
200 100 100


It doesn't look to me as if a running total will be of much benefit. Do I have to do this by hand - creating variable and doing the math myself?

 

[synapsevampire]

Place your date field (sorted by this of course).

Flank CHGS and PMTS with these 2 formula fields:

//Beg A/R
previous({@End A/R})

//End A/R
evaluateafter(@Beg a/r);
({@Beg A/R} + {MyTable.chgs})- {MyTable.pmts}

Should work.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dean12]

Previous - darn that was what I needed.

Thanks very much.