How do you null out numeric data? I have a DEFINE field to do some computation but is the answer equals 0, I want null or '' to show instead of 100%.

DEFINE field:
MTD_PCT/D10.1%=IF (MTD/&MTDCNT)*100 NE 100 THEN (MTD/&MTDCNT)*100 ELSE ???;

Try this.

DEFINE field:
MTD_PCT/D10.1% MISSING ON NEEDS SOME=IF (MTD/&MTDCNT)*100 NE 100 THEN (MTD/&MTDCNT)*100 ELSE MISSING;

I should've mentioned I tried using MISSING. No luck. Throws an error.

S is zero-suppress
MTD_PCT/D10.1%S = whatever.
Works nicely on integer fields
FIELNAME/I8S is one of my favorites

Thanks