topic MTD and YTD help on KPI object in App Development

MTD and YTD help on KPI object

Thu, 23 Feb 2017 17:37:16 GMT

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 — Thu, 23 Feb 2017 18:36:55 GMT

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 — Thu, 23 Feb 2017 18:43:49 GMT

Try this.

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

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

Removed the double Quotes from field name.

Regards,

Kaushik Solanki