Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Null out numeric data?
Go
New
Search
Notify
Tools
Reply
  
Null out numeric data?
 Login/Join
 
<kvn>
posted
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 ???;
 
Reply With QuoteReport This Post
<WFUser>
posted
Try this.

DEFINE field:
MTD_PCT/D10.1% MISSING ON NEEDS SOME=IF (MTD/&MTDCNT)*100 NE 100 THEN (MTD/&MTDCNT)*100 ELSE MISSING;
 
Reply With QuoteReport This Post
<kvn>
posted
I should've mentioned I tried using MISSING. No luck. Throws an error.
 
Reply With QuoteReport This Post
Expert
posted Hide Post
S is zero-suppress
MTD_PCT/D10.1%S = whatever.
Works nicely on integer fields
FIELNAME/I8S is one of my favorites
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
<kvn>
posted
Thanks
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Null out numeric data?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.