Cross tab aging

[RWahlert]

I'm trying to creat an aging report based on the due date of the invoice. I would like to use a cross tab report and the aging functions of Crystal. I have formuals created (Example: DueDate in Aged0to30Days)for each of the aging periods I want, and have placed them in the columns and have placed the transaction amount in the summarized area. The rows are my customer names.

When I run the report I am getting column headings that say True and False. I am guessing the boolean that is being returned refers to whether or not the due date falls within that aging period.

Does anyone have any ideas how I rewrite my formula so that I would only have the aging periods as the column header and display just the amount in the field?

Thanks.

Ralph

 

[gav12345]

Hi Ralph,

I think you need an 'if' statement in your formulas. i.e.:

if DueDate in Aged0to30Days then
   DueDate

Gavin

 

[lbass]

Create a formula like the following to use as your column field:

if {table.duedate} in Aged0to30Days then "Aged 0 to 30 Days" else
if {table.duedate} in Aged31to60Days then "Aged 31 to 60 Days" else
if {table.duedate} in Aged61to90Days then "Aged 61 to 90 Days" else
if {table.duedate} in Over90Days then "Over 90 Days"

-LB