Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to created a Dashboard for my sales performance and I would like to have 2 KPI objects: MTD and YTD
Sum({1<"MONTH"={"$(=Month(Today()))"}>}ORDERS)
Sum({1<"YEAR"={"$(=YEAR(Today()))"}>}ORDERS)
This is not working, any clues on what I am doing wrong?
Renata
I don't see any issue except that MTD will include the whole Month of Feb and YTD will include Whole Year 2017. Is that what you want?
Try this.
Sum({1<MONTH={"$(=Month(Today()))"}>}ORDERS)
Sum({1<YEAR={"$(=YEAR(Today()))"}>}ORDERS)
Removed the double Quotes from field name.
Regards,
Kaushik Solanki