8 Replies Latest reply on Sep 10, 2018 12:56 PM by Susan Kurian

    Finding Max Term and then do calculations based on that

    Susan Kurian

      Hello,

       

      I am trying to find the max term of the data we currently have and then find out the 3rd oldest term relative to that and show number difference based on the max term. Attached is the worksheet I have along with the data. I created a field called Calc_Max Term_Year. I was hoping to get the value as '2015', but I don't.

       

      Not sure what I am doing wrong.

       

      Please help.

       

      Thanks,

      Susan