Hi,

I have a column in my report which needs to display values in the format XX,XXX.YY (i.e with thousand separator and decimal point).
I did this with the below code

DEFINE FILE HOLD
COLUMN_1/D20.2C=COLUMN_1;
END

But now, rows with 'NULL' value is replaced as '.00'

I tried giving COLUMN_1/D20.2C inside the

 TABLE FILE HOLD 

But then the subtotal values were displayed without commas.

Is there a work around for this issue?

Thanks,
Ajai

This message has been edited. Last edited by: Ajai,

quote:

COLUMN_1/D20.2C=COLUMN_1;

Read up about MISSING in the online help

Thankyou JG. I tried the MISSING command and worked perfectly.

Thank,
Ajai

The following example will do what you need:

 
TABLE FILE CAR
PRINT DEALER_COST
BY COUNTRY
BY CAR
BY MODEL
ACROSS BODYTYPE
ON TABLE HOLD FORMAT ALPHA
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDMISS ON
END

DEFINE FILE HOLD
COLTST/D20.2C MISSING ON = DEASEDAN;
END
TABLE FILE HOLD
PRINT * COLTST
END
 

Hope this helps ...

Yes GamP, I did exactly the same.

Thanks,
Ajai.