I have a table that contains fields where zero is a valid number but the fields can also contain blank (null) values which are also valid.
When I add a format to the field in my fex (for example "/D10CBM") the resulting report produces "$0" in place of the null when what I actually want is the null.
Is there a way to preserve the null value and only display $0 when the field contains an actual zero rather than a null?
Thanks in advance for your help!This message has been edited. Last edited by: manglum,
WebFOCUS 8 Windows, All Outputs
November 09, 2017, 12:02 PM
eric.woerle
Manglum,
you want to add missing on to your define field. try this:
MY_FIELD/D10CBM MISSING ON
also the default value for null is "." if you want to display blank or something else, you need to set that with
SET NODATA = ''
There is also a set command for Null as well. Does the same thing as missing = on, but it turns it on for all fields, not just the one you set it on
Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2
November 09, 2017, 12:14 PM
manglum
THATS A WINNER!!!
WebFOCUS 8 Windows, All Outputs
November 09, 2017, 06:48 PM
Doug
You're a Winner Matt
You too eric, for knowing that and passing it on.
Share the wealth (of information)...
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206