AnsweredAssumed Answered

Error trapping on ExecuteSQL

Question asked by Stu412 on Apr 23, 2015
Latest reply on Apr 23, 2015 by Stu412


Error trapping on ExecuteSQL


Hi there

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.