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!