How to get a first value of line item
I have requirement where I need to identify the first value of Borrowing line item and that value would flow into initial commitment. So I have used ISFIRSTOCCURENCE with a logic IF Borrowing <> 0 THEN ISFIRSTOCCURRENCE(Borrowing, Revolver Facility) ELSE FALSE but this will giving me two occurrence.
what I need is the first value of Borrowing into the initial commitment for ex: 3/2/2022 value of Borrowing(700) into initial commitment only that value
The list which I have used is custom dates list which I have created.