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,

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

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

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