AnsweredAssumed Answered

Difference in Portal Rows

Question asked by daveobrien8 on Mar 14, 2016
Latest reply on Mar 14, 2016 by mikebeargie

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

Outcomes