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!
You need the GetNthRecord function which allows you to compare your current record's value against another records value in the same found set (or portal).
Here's a good blog post about using it: