SET MISSINGTEST Command

You can use the SET MISSINGTEST command to eliminate the missing test for an IF expression so that either the THEN expression or the ELSE expression will be evaluated and returned as the result. The MISSINGTEST parameter has a new option, NEW, which is the default value. In previous releases, OLD was the default value.

The MISSINGTEST parameter has been added to the Set canvas, as shown in the following image.

Possible values are:

• NEW excludes the IF expression from the missing values evaluation so that it results in either true or false, not MISSING. If it evaluates to true, the THEN expression is used to calculate the result. If it evaluates to false, the ELSE expression is used to calculate the result. This is the default value.
• OLD includes the IF expression in the missing values evaluation. If the IF expression evaluates to MISSING, the result is also MISSING, if the missing field only needs some missing values.
• SPECIAL is required to pass parameters to RStat functions.

Learn More

For more information on the SET MISSINGTEST command and other SET commands, see the Creating Reports With WebFOCUS Language and the Developing Reporting Applications technical content in the Technical Library.