Aging Report

[CrystalVis]

I need help to create formula for Aging Report. I need to sum the amount by past due date. For example,

1 to 30 31 to 60 61 to 90 91 to 120 over 120
$950.12 $850.55 $750.25 $123.52 $50.55

I used Crystal build-in function 31to61 and 61to90 that take care two columns. I'm not sure if I have the following formula correct

({Ord.process_date} + 1) in Aged0To30Days to capture the amount past due between 1 to 30 days.

{Ord.process_date} < (currentdate - 120) to capture the amount past due over 120 days.

I'm not sure how to capture the amount past due between 91to120days.

Can you please tell me if my formulas are corrected and how to capture the past due amount between 91to120 days. Your help is greatly appreciated.

 

[Naith]

Your formulas look sound.

91 to 120 can be attained like this:

{Ord.process_date} < CurrentDate-90 and
{Ord.process_date} > CurrentDate-120

Naith

 

[cutiger93]

I am working on an aging report as well. I would like to supress the GF1,GF2,etc based up the following detail. If the days are over 90 and the values are negative then I want to see all of these items. When I use the format and surpress based upon the flag that I have created, it only suppresses the values in the detail. Any ideas would be apprecitative.