1 Reply Latest reply on Oct 26, 2018 1:15 PM by Michael Smith

    Difference in Value, two variables

    Michael Smith

      I'm hoping for some feedback and advice on creating a calculated field that provides the value I am looking for.

      I am trying to calculate the difference in value between ranks, per year. 

      Example: If a school is ranked 4th in 2014, what is the funding value difference between the 4th and 3rd ranked school (in 2014).

      Ideally, there would be an expression that would express the difference for each year represented and the total for all years shown.