7 Replies Latest reply on Jun 20, 2018 10:16 AM by Deepak Rai

    Calculate difference between the measure in max year and the year before

    Diogo Braga

      The goal is to calculate the difference between the measure in max year and the year before.

      I got part of the solution here...but unsure how to combine it a way to work.

       

      {FIXED [School Code]: IF MAX([Year]) THEN SUM([School Grade (Numerical)]) END}

      -

      {FIXED [School Code]: IF {MAX([Year])}-1 THEN SUM([School Grade (Numerical)]) END}

       

      2018-06-20_1220.png

       

      2018-06-20_1227.png