1 Reply Latest reply on Jun 27, 2018 7:20 AM by Shinichiro Murakami

    Need Help with YoY Change

    Tyler Penn

      I am trying to do a YoY % change calculation and using calculated dates. I have 13 months of data not aggregated and want to use the min/max function to select my dates. My dates are listed as 201805, 201705, etc. I currently have to manually change the dates every time is there anyway to use those functions to get away from manually doing the calculation. See below:

       

      (SUM(IF [As Of Date]=201805 THEN [Src Outstandings Amt] END)

      -

      SUM(IF [As Of Date]=201705 THEN [Src Outstandings Amt] END))

      /

      SUM(IF [As Of Date]=201705 THEN [Src Outstandings Amt] END)

        • 1. Re: Need Help with YoY Change
          Shinichiro Murakami

          HI Tyler,

           

          Without seeing any data, but try below.

           

          (SUM(IF [As Of Date]={fixed :max( [As Of Date])} THEN [Src Outstandings Amt] END)

          -

          SUM(IF [As Of Date]={fixed :min( [As Of Date])} THEN [Src Outstandings Amt] END))

          /

          SUM(IF [As Of Date]={fixed :min( [As Of Date])} THEN [Src Outstandings Amt] END)

           

           

          Thanks,

          Shin