Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I calculate?
YTD, LYTD, MTD and LMTD Sales (KPI objects) based on "Order Date" considering the present date is 29-Dec-2012. Consider Jan to Dec financial year.
Many Thanks.
In that case, create a calendar till 29-Dec-2012.
Then your max(Date) will be 29-Dec-2012 and you can calculate MTD, YTD from that max date.
Hello,
You can check below link for expressions.
I have a question regarding Present date as 29-Dec-2012, what does that mean ?
Thanks,
Ashutosh
In that case, create a calendar till 29-Dec-2012.
Then your max(Date) will be 29-Dec-2012 and you can calculate MTD, YTD from that max date.