1 Reply Latest reply on Oct 26, 2017 4:45 AM by Norbert Maijoor

    How to compare MTD and Last year MTD

    monika sheoran

      we want to MTD and Last year MTD in bar chart. If MTD is greater then last year MTD then arrow symbol is showed up otherwise down.

      How is it possible?

      My requirement is given below

        • 1. Re: How to compare MTD and Last year MTD
          Norbert Maijoor

          Hi Monika,

           

          Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread.

           

           

          1. today LY: DATEADD('year',-1,today())

           

          2. MTD: if DATEDIFF('month',[date],today())=0  and [date]<today() then [value] END

           

          3. MTD LY: if DATEDIFF('month',[date],[Today LY])=0  and [date]<[Today LY] then [value] END

           

          4. up/down: if sum([MTD])<sum([MTD LY]) then "down" else "up" END

           

          5. YTD: if DATEDIFF('year',[date],today())=0  and [date]<today() then [value] END

           

          6. YTD LY: if DATEDIFF('year',[date],[Today LY])=0  and [date]<[Today LY] then [value] END

           

          7. up/down Y: if sum([YTD ])<sum([YTD LY ]) then "down" else "up" END

           

          Regards,

          Norbert