4 Replies Latest reply on Sep 18, 2018 6:59 AM by dinesh punnam

    YTD - ROY Labels

    dinesh punnam

      Hello All,

       

      I want to display the date ranges for YTD, ROY etc

       

      I calculated the YTD & ROY metrics , but user want to see some thing like this in the label YTD ( 01/01/2018 to 09/13/2018) so that on a glace they will know what date ranges they are looking into .

       

       

      ROY

      MONTH([Transaction Date]) > MONTH(TODAY()) AND 

      DATEDIFF("year",[Transaction Date],[Year Parameter])=0

       

      YTD

       

       

      MONTH([Transaction Date]) <= MONTH(TODAY()) AND 

      DATEDIFF("year",[Transaction Date],[Year Parameter])=0

       


      Thanks in advance !