Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get 12 month rolling trend from a date field in the script?
If(DATEFIELD>addmonths(Today(), -12), 1) as Rolling12MonthsFlag
Then you can use Set Analysis with your new calendar flag field to only look at the rolling 12 months.
If you have future dates as well:
If(DATEFIELD>addmonths(Today(), -12) and DATEFIELD<=Today(), 1) as Rolling12MonthsFlag
If there is multiple date fields which needs to be shown the 12 month trend
and how can we make use of variables up here?
eg:
process date
pending date
complete date
12 month trend to each field.
On Sun, Nov 25, 2012 at 11:53 PM, Johannes Sunden