I have a relation (xRel) and a derived field (DerivedxRelCount) that is returning an instance count of leave requests in our system that will expire within the next 31 days.
The instance count does a good job as a flag to identify which individual records will expire, but I would like to create an additional field that returns the total/sum of the instance count for the business class that meets this condition.
Is there a way to do this with LPL?
Our Data looks something like the table below and I would like to have a derived/compute field to return the value "3".
| Employee ID |
Leave Reason |
Start Date |
End Date |
DerivedxRelCount |
| 1 |
FMLA |
1/1/2024 |
8/30/2024 |
1 |
| 2 |
Workers Comp |
2/1/2024 |
7/31/2024 |
|
| 3 |
Maternity |
6/1/2024 |
9/1/2024 |
1 |
| 4 |
Bereavement |
4/1/2024 |
8/14/2024 |
1 |
