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.

       

      Thks

       

      Bill

       

      Capture.GIF