Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking to creating aging summary that breaks the balance between debits and credits, but I am trouble getting it to work correctly.
So far I have the formula to get balance for 0-30 bucket and 3160 bucket and so on. Could anyone explain how I would create a formula to seperate the balance between the debit and credit amount for each bucket?
$(Bucket030)
$(Bucket3160)
$(TotalAdjustmentAmount)
No, I don't have a flag. I created chart/query to run an aging summary by bucket. An example of my aging summary is below.
Bucket 0-30 | Bucket 31-60 | Bucket 61-90 | Bucket 91-120 | Bucket 121-150 | Bucket 151-180 | Bucket 181-210 | Bucket Over 210 | Total Amount |
$32,690.00 | $27,480.00 | $6,645.00 | $3,705.00 | $460.00 | ($485.00) | $3,640.00 | ($140.00) | $73,995.00 |
For each of these balances I an trying to separate what is debit and credit balance for each bucket. Any help would be greatly appreciated.
Mike
Can you please elaborate on it?
Do you have a FLAG which says its debit/credit or is the value negative and positive?
No, I don't have a flag. I created chart/query to run an aging summary by bucket. An example of my aging summary is below.
Bucket 0-30 | Bucket 31-60 | Bucket 61-90 | Bucket 91-120 | Bucket 121-150 | Bucket 151-180 | Bucket 181-210 | Bucket Over 210 | Total Amount |
$32,690.00 | $27,480.00 | $6,645.00 | $3,705.00 | $460.00 | ($485.00) | $3,640.00 | ($140.00) | $73,995.00 |
For each of these balances I an trying to separate what is debit and credit balance for each bucket. Any help would be greatly appreciated.
Mike
Mike,
Do you have solution for this question. If so, do you mine share with us.