Excel IFERROR equivalent in Mendix

0
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
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:

answered