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     [SOLVED] DECIMAL DON'T SHOW ZERO'S
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] DECIMAL DON'T SHOW ZERO'S
 Login/Join
 
Platinum Member
posted
Hi,

I want to supress my Zero Values.
My Format is D12.2, but when there is a Zero I get 0,00
How can I just get a normal 0??

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Guru
posted Hide Post
This works if you have no other missing values in the report:

SET NODATA = 0
TABLE FILE CAR
PRINT
COMPUTE TST/D12.2 MISSING ON = IF CAR EQ 'AUDI' THEN MISSING ELSE CAR.BODY.DEALER_COST / CAR.BODY.RETAIL_COST;
BY CAR.COMP.CAR

END


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 435 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
This is exactly what I wanted, but it's still a little tricky.. I want to use a dynamic Format:

MYFORMAT/A8=DECODE ASSETTYP ('Spezial-Fonds' 'D12.4' ELSE 'D12.2');

MIFID_TRX_EA_TEST/MYFORMAT MISSING ON = IF MIFID_TRX_EA EQ 0 THEN MISSING ELSE MIFID_TRX_EA;

but I get a error...


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I think the problem is with having the dynamic format and MISSING ON in the same line. If you can use a DEFINE instead of a COMPUTE here's a way you can get what you want.
 
DEFINE FILE CAR
FMT/A8 = DECODE COUNTRY('ENGLAND' 'D12.4' ELSE 'D12.0');
NEW_SALES MISSING ON = IF SALES EQ 0 THEN MISSING ELSE SALES;
END
TABLE FILE CAR
SUM NEW_SALES/FMT
BY COUNTRY 
BY CAR     
BY MODEL
END 


WebFOCUS 8206, Unix, Windows
 
Posts: 1846 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] DECIMAL DON'T SHOW ZERO'S

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