October 19, 2004, 08:05 PM<kvn>
Null out numeric data?
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%.
MTD_PCT/D10.1%=IF (MTD/&MTDCNT)*100 NE 100 THEN (MTD/&MTDCNT)*100 ELSE ???;
October 20, 2004, 03:03 AM<WFUser>
MTD_PCT/D10.1% MISSING ON NEEDS SOME=IF (MTD/&MTDCNT)*100 NE 100 THEN (MTD/&MTDCNT)*100 ELSE MISSING;
October 20, 2004, 02:04 PM<kvn>
I should've mentioned I tried using MISSING. No luck. Throws an error.
October 20, 2004, 09:08 PMsusannah
S is zero-suppress
MTD_PCT/D10.1%S = whatever.
Works nicely on integer fields
FIELNAME/I8S is one of my favorites
October 25, 2004, 07:27 PM<kvn>