1 Reply Latest reply on Mar 14, 2016 5:03 PM by mikebeargie

    Difference in Portal Rows

    daveobrien8

      Hi -

       

      I am hoping someone can tell me how to write a calculation to find the difference between 2 portal rows.

       

      I want to show the dollar amount or percentage between pay rates.  The portal can have many rows, I would like to show the difference between the previous row and the current one.

       

      As in the example below, I want to know the difference between row 3 and 2 and then row 2 and 1.  (Row 3 should be the same as the rate amount if there isn't a row below it.)  The portal is sorted by date of rate change, and linked to each employee.

       

      1 date of rate     rate amount    difference

      2 date of rate     rate amount    difference

      3 date of rate     rate amount    difference

       

      Any help would very much be appreciated!

       

      My Best,

      Dave