Focal Point
Null out numeric data?

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5181008331

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%.

DEFINE field:
MTD_PCT/D10.1%=IF (MTD/&MTDCNT)*100 NE 100 THEN (MTD/&MTDCNT)*100 ELSE ???;
October 20, 2004, 03:03 AM
<WFUser>
Try this.

DEFINE field:
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 PM
susannah
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>
Thanks