October 19, 2007, 12:28 PM
Agnes YeungWebFocus report
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');
October 19, 2007, 01:32 PM
PrarieWhich field...and What are you trying to accomplish with the N/A?
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
October 19, 2007, 02:54 PM
LeahIf the field you want to have N/A in is one with missing information, have you tried the
SET NODATA = 'N/A' option?
Leah
October 19, 2007, 04:46 PM
FernandoAgnes,
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
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
October 22, 2007, 10:11 AM
Agnes YeungThe 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.
WebFOCUS 766
Windows XP
Output: HTML, PDF or Excel, per users' preference