Skip to Content
0
Former Member
Jul 12, 2007 at 04:18 PM

Changing aging buckets in Crystal

39 Views

Post Author: jshynes

CA Forum: Formula

I need to have a custom aging buckets (ranges) created in Crystal.

I use CRXI, MSSql database. pretty much a new user.

I'm also aware of the functions Aged0to30days, Aged31to60days etc... but I need the ranges to be different. Is there anyway to use a formula to create a custom date range so that it'll be 0-60, 61-90, 91-120, 120-180 and over 180 days? The data is invoice dates and invoice amounts.

If noone has an example, can you point me in the direction or suggest for other resources.

Thanks,

Dude