How to create a formula to seperate debits and credits on a aging summary report.

[#1]

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)

[boorgura]

Can you please elaborate on it?

Do you have a FLAG which says its debit/credit or is the value negative and positive?

[#3 · Accepted solution]

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

[#4]

Mike,

Do you have solution for this question. If so, do you mine share with us.