Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi together,
I want to create an aging analysis
(
)
for the last rolling 12 months based on a reporting day.
I have created the aging expressions, but I couldn't define the 12 rolling months.
Has anyone did something like this before?
thanks and regards
Bumin
Kiran,
I want to see only the 12 last months
The report should show the aging as
per last month
per last month -1
per last month -2
...
So each bucket has to show all documents with their aging regarding the period's monthend
regards
Bumin
Bumin,
What I would recommened is in load script create a field called document_ageing which should return Open, <30,<60 ,30-60 etc.
Then you can create this chart with document_ageing, calendar_month and count({<MonthID<={"$(=VL12Months)"}>}document_number). This would be very light and easy to use solution.
Kiran.