I have a cross-tab report with clients as the rows and dates as the columns. In each "cell" of the cross tab are two numbers. (1) The amount I have billed the client that day and (2) The amount I have received from the client that day. This works perfectly.
I would now like to add a third amount in each "cell". This number should be the amount of the previous day's billings minus the previous day's receipts (called "balance forward"
.
I would then like to add the "balance forward" to the next days (Billings-Receipts). The end result should be a total due (a running total) of the client's balance at the end of each day. This would essentially be a "trend" of their balance througout the week.
Any help is greatly appreciated!
I would now like to add a third amount in each "cell". This number should be the amount of the previous day's billings minus the previous day's receipts (called "balance forward"
. I would then like to add the "balance forward" to the next days (Billings-Receipts). The end result should be a total due (a running total) of the client's balance at the end of each day. This would essentially be a "trend" of their balance througout the week.
Any help is greatly appreciated!