2 Replies Latest reply: Feb 23, 2017 1:43 PM by Kaushik Solanki RSS

    MTD and YTD help on KPI object

    Renata Campos

      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