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

    How to compare MTD and Last year MTD

    monika sheoran
    monika sheoran Oct 26, 2017 4:26 AM

      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

      • 167 Views
      • Tags:
        • 1. Re: How to compare MTD and Last year MTD
          Norbert Maijoor
          Norbert Maijoor Ambassador Oct 26, 2017 4:45 AM (in response to monika sheoran)

          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