Focal Point
[CANCELLED]NULL value using a WHERE clause

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

May 10, 2013, 10:20 AM
Ted Michalski
[CANCELLED]NULL value using a WHERE clause
If a WHERE clause fails I get NULLS for the value of the field I'm trying to display. I would like to display 0.00 instead of NULLS.
I have tried to use the MISSING command with no success. Can anyone make a suggestion?

This message has been edited. Last edited by: Ted Michalski,


7.7.02
Windows
EXCEL, PDF, CSV, TEXT
May 10, 2013, 12:19 PM
Rao D
Did you try using SET NODATA = 0.00 ?


WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012
AppStudio