MTD and YTD help on KPI object

[#1]

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

[sunny_talwar]

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?

[kaushiknsolanki]

Try this.

Sum({1<MONTH={"$(=Month(Today()))"}>}ORDERS)

Sum({1<YEAR={"$(=YEAR(Today()))"}>}ORDERS)

Removed the double Quotes from field name.

Regards,

Kaushik Solanki