Canvas Apps UDFs - udfSafeDivision
No More Divide-by-Zero issues - udfSafeDivision (Canvas Apps UDF miniseries)
No More Divide-by-Zero issues - udfSafeDivision (Canvas Apps UDF miniseries)
Problem: multiple uncontrolled divisions in your calculation logic that may break your app. Make it a practice to wrap it, and you will thank me later!
Function:
udfSafeDivision(Numerator: Number, Denominator: Number): Number = IfError(Numerator / Denominator, 0)
Returns 0 when the denominator is 0.
Sample implementation in calculation is counting averages - udfSafeDivision(Sum(colSales, Amount), CountRows(colSales))
Refactor tip: search for "/" (will return most likely either comments or division) and upgrade to this UDF!
Browse articles