I have a report coded like this:

TABLE FILE LTC005HOLD
SUM
CNT.LTC005HOLD.SEG01.CLM_STATUS AS 'Claim Count'
BY LTC005HOLD.SEG01.Group_ID NOPRINT AS 'Group:'
BY LTC005HOLD.SEG01.Mbr_Name AS 'Member Name'
BY LTC005HOLD.SEG01.Member_ID_Number AS 'Member ID'
BY LTC005HOLD.SEG01.CLM_STATUS AS 'Claim Status'

The user wants to display “N/A” in the Claim Count column when the Claim Status is “No Claims”
The way my report is coded it is displaying 1 for these rows.

The user wants this :
CLAIM STATUS CLAIM COUNT
------------ -----------
No Claims N/A
Denied Claims 4

My report is giving this:
CLAIM STATUS CLAIM COUNT
------------ -----------
No Claims 1
Denied Claims 4

Does anyone know of a simple way to do what the client wants?

This might do it:

TABLE FILE CAR
SUM
-*CNT.WHEELBASE
COMPUTE CNT_WHEELBASE/P9C MISSING ON = IF COUNTRY EQ 'JAPAN' THEN MISSING ELSE CNT.WHEELBASE;
BY COUNTRY

ON TABLE SET NODATA N/A
END