As a Sugar Support engineer, I’ve seen errors like this several times:
[FATAL] Exception evaluating expression in SetValueAction, divide($currencyone_c,$currencytwo_c) : Division by zero
This happens when a calculated field includes a formula similar to the one below:
divide($currencyone_c, $currencytwo_c)
If $currencytwo_c is NULL or zero, Sugar throws an error since division by zero isn’t possible. To prevent this, you can modify your formula using ifElse to check for zero values before performing the division. I included an example below:
ifElse(equal($currencytwo_c, 0),
"0",
divide($currencyone_c, $currencytwo_c)
)
This ensures that if $currencytwo_c is zero, the formula returns "0" instead of causing an error. You could also use greaterThan($currencytwo_c, 0) to ensure division only occurs when the denominator is positive.
Have you encountered this issue before? Let me know if you have other approaches to handling this!