Hi,
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.
Solved!去解决方案。
Hi@anikdas,
I will go with the second option as it would not give performance issues in future.
Thanks for your help