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