2 Replies Latest reply: May 30, 2018 7:19 AM by Nitin Gaikwad RSS

    Calculating Difference Current v. Prior Year

    David Cox

      We need to calculate and use in a line graph the difference, based on ID, of the prior year v. current year.


      So far, we have 2 years but this will need to work generally.  Naturally the first year 2015 would have no "difference" record.  The subsequent years would.


        

      IDYearRatio
      100163820163.57
      100163820154.18
      100334620150.25
      100334620162.19
      100375020150.49
      100375020160.50
      100376420153.07
      100376420164.07
      100376720162.11
      100376720152.26

       

      We are calculating the ratio, currently, as a measure.


      Is this all best done in the load script, or as a calculated measure?