Hello,
I've designed a report which contains ITEM, MNTHLY_PMNT, and ORIG_AMT fields. Each ITEM has multiple rows for MNTHLY_PMNT and ORIG_AMT.
I'm trying to add a formula field ( REM_BAL) that will output the following.
- for the first row of each new ITEM, subtract MNTHLY_AMT from ORIG_AMT
- for following rows for the same ITEM, subtract current row's MNTHLY_AMT from the previous row's REM_BAL.
I have created a global function and tried applying my limited knowledge to figure out some logic, but that didnt get me anywhere. I'd appreciate it if someone could guide me through this.
Thanks
IP Logged
