I have a report with calculated percent displayed. This calculated fields are in a matrix report with FOR clause. I tried to change some of this data to 'N/A' but failed. Please advise how. See the codes.

DEFINE FILE DLHCMR4_RELEASE4
COL_DEF/A35 =
IF CARD_TYPE_MEMBER EQ 'CT.DLCARD_V1' THEN 'DL' ELSE
IF CARD_TYPE_MEMBER EQ 'CT.HCARD_V1' THEN 'HC'
ELSE ' ';
END
TABLE FILE DLHCMR4_RELEASE4
SUM
ITEM_COUNT/I9C AS ' '
ACROSS
COL_DEF AS ' '
FOR
EVENTS_MEMBER
'ES.CPCBATCH_S' AS 'Orders Received by CPC' LABEL R1 OVER
'FPS_CARD_DAMAGED' OR 'FPS_DATA_QUALITY' OR 'FPS_IMAGE_QUALITY' OR 'FPS_INC_DATA' OR 'FPS_SIGNATURE_QUALITY' AS 'Final Production Failures *' LABEL R2 OVER
'ES.MAIL_S' OR 'ES.MAIL_P' AS 'Mailed' LABEL R3 OVER
'ER.REQ_CANCEL' AS 'Cancelled via Online Pull' LABEL R4 OVER
'FPS_CARD_DAMAGED' OR 'FPS_DATA_QUALITY' OR 'FPS_IMAGE_QUALITY' OR 'FPS_INC_DATA' OR 'FPS_SIGNATURE_QUALITY' OR 'ES.MAIL_S' OR 'ES.MAIL_P' OR 'ER.REQ_CANCEL' AS 'Total Orders Processed' LABEL R5 OVER
RECAP R6=(R1-R5); AS 'Outage **' OVER
'ES.QA_LVL_2_F' OR 'ES.QA_LVL_2_S' AS ' ' LABEL R7 NOPRINT OVER
COMPUTE HEALTH_QA_OUT/D5.2%L = 100 * ( R7 / R1 ); AS 'Health Level 2 QA %'
WHERE ( CARD_TYPE_MEMBER EQ 'CT.DLCARD_V1' OR 'CT.HCARD_V1' ) AND (ORDER_BATCH_MEMBER EQ '&WH_CRI');

Which field...and What are you trying to accomplish with the N/A?

If the field you want to have N/A in is one with missing information, have you tried the
SET NODATA = 'N/A' option?

Agnes,

Is this what you want?

DEFINE FILE DLHCMR4_RELEASE4
COL_DEF/A35 MISSING ON=
IF CARD_TYPE_MEMBER EQ 'CT.DLCARD_V1' THEN 'DL' ELSE
IF CARD_TYPE_MEMBER EQ 'CT.HCARD_V1' THEN 'HC'
ELSE MISSING;
END

Used in combination with:

SET NODATA = 'N/A'

You will get N/A for this column.

Fernando

The fields under the column 'DL' and row total column are intended to display 'N/A' for the row labeled 'Health Level 2 QA %' while the field HEALTH_QA_OUT is intended for display only in the column of 'HC' on that row.