2 Replies Latest reply on Nov 21, 2018 5:22 PM by Bill Bay

    Calculate difference between 2 rows, without using table calculation

    Bill Bay

      Hi all,


      pls refer to attached screen shot for reference. I need help on how to create a calculated field "Change". see table 1 - yellow column. the other 3 column in table 1 are my raw data.


      This Change column will be = current month's "Grade" minus previous month's "Grade". My intended view is shown is table 2 - based on month filter=Feb-18.


      All the solution I found on internet are using Table calculation, using Lookup, which required me to display Jan-18 in the view too for it to work. In my case here I will be filtering to display 1 month at a time. so I do not think table calculation will work for me.