I have the following fields
DaysLeaveDue=30 (Fixed value)
These fields are placed in a portal in a relatted table and each time leave is taken the entires are made as a LineItem within the portal.
The problem is how to get the BalanceLeave Due calculation to show a running total of leave due for each LineItem.In Other words I want it to read the BalanceLeaveDue of the last entry:
Just in case I am not making myself clear here is an example:
DaysAbsent=3 days (LineItem 1) therefore BalanceLeaveDue results 27 Days
DaysAbsent=2 days(LineItem2) " " 25 Days (I am not getting this result,instead I am getting 27Days)