I am currently trying to convert an Excel formula into a microflow, but I cannot figure out how to do Mendix’ version of IFERROR. =IFERROR(SUM(LReducePPICol)*(1-ComNum/ComNum)-SUMIF(TypeCol,"PPI",CreditCol)*(1-ComNum/ComNum),0) In this context, Excel’s IFERROR catches an exception of division by zero when ComNum = 0. This is the mendix calculation without use of IFERROR. Can someone fix the expression or guide me on how to. $Sum_LitActualPpi * (1 - $CaseData/ComRate : $CaseData/ComRate) - $Sum_Credit_ByPpi * (1 - $CaseData/ComRate : $CaseData/ComRate) Thanks
asked
Lee Stevens
1 answers
2
The Mendix way to do this is to make a separate flow that takes care of this calculation and in that flow use errorhandling: