I created 6 formula one for 0-30 then 31-60, etc thru Over 150. I want the report to print the balance of an account in the correct bucket based on discharge date and then the other buckets report a 0.00.
My issue is if an account is over 150 days old the balance will result in all buckets vs just the last bucket.
if {PD_CDDPDRACCMAS_RECORD.CH_DIS_DT}>=currentdate-4000 to currentdate-151
then {PD_CDDPDRACCMAS_RECORD.CH_PT_DUE_AMT}
How it looks
Acct# 0-30 31-60 61-90 91-120 121-150 Over 150
11111 15.00 15.00 15.00 15.00 15.00 15.00
How I want it to look
Acct# 0-30 31-60 61-90 91-120 121-150 Over 150
111111 0.00 0.00 0.00 0.00 0.00 15.00
If an account is 93 days olf then the balance will result in 0-30,31-60,61-90 and 91-120 when I only want it to result in bucket 91-120.
if {PD_CDDPDRACCMAS_RECORD.CH_DIS_DT}>=currentdate-120 to currentdate-91
then {PD_CDDPDRACCMAS_RECORD.CH_PT_DUE_AMT}
How do I accomplish what I want?
IP Logged
