The Excel Version of the Formula I'm trying to write is =MIN(ROUND(ABS(((UI20+UJ9)-UJ40)/Collection_Funding!UI3),2),0.98)
The Formula I'm trying to use is MIN(ROUND(ABS(((previouse(total eligible principle)+paydown)-Min Assesset Requirment)/Previouse(Collection Funding!RTR)), 2), 0.98), which I do not believe is 100% correct.
Functions I'm using (MIN, ROUND, ABS, PREVIOUS)
Line Items (UI20=total eligible principle, UJ9=paydown, UJ40=Min Assesset Requirment, UI3=RTR) All my Line Items are Number Formatted.
Please advice on how I should create this formula.
I highly recommend you breaking that up for performance reasons as well as being able to debug it. Also, I would suggest you placing the literal (0.98) in a SYS Global module so if that ever changes, you change it one spot instead of having to hunt around for all line items that are hardcoded.