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.