I am trying to insert NULL into a field so that the column will display blanks rather than zeroes. I am trying to do this within a DEFINE of a virtual field.
e.g.
DEFINE fieldA/I5 = IF conditionA THEN value1 ELSE NULL
is what I am trying to accomplish.

This message has been edited. Last edited by: <Kathryn Henning>,

Here is the WebFOCUS syntax for what you want to do:

DEFINE fieldA/I5 MISSING ON = IF conditionA THEN value1 ELSE MISSING;

In order for the column to display blanks, you will need to issue this command:

SET NODATA = ' '

You can also do this:

DEFINE fieldA/I5S = IF conditionA THEN value1 ELSE 0 ;

The "S" in the field format indicates to suppress the display of zero and to show a blank instead.

I am trying to do this as well on INFOAssist. The define window works slightly different than regular WebFOCUS when defining. How would this be done?