Error trapping on ExecuteSQL
Let's say I have a very simple SQL query which results in division by zero for a certain circumstance. For 99% of the time, it's fine. The code is a very simple (X-Y)/X to get a profit percentage.
What's the best way to get rid of the resulting '?' when there's division by zero?
Normally is SQL I'd use an ISNULL before the field name, but I cannot seem to get this to work in FM.