Return to FileMaker.com
Suppressing a "?"
I developed a calculated field, (a - b)/b, which shows growth of a relative to b for a period. The problem is that when b = 0, FM displays a "?", which makes sense when you divide by 0.
I would like to suppress the "?" when it results from dividing by 0.
If ( b = 0 ; "" ; (a -b)/b )
Or you can use: If ( b ≠ 0 ; ( a - b ) / b )
You can put any value you want in place of ""--which returns an empty string to leave the field empty in my first example.
Retrieving data ...