Could some please point me in the right direction for any documentation on this?
My Code:
JOIN CLEAR *
JOIN
ACTIVEPOP.EMP_SSN
IN ACTIVEPOP TO ALL CEESTATUS.EMP_SSN
IN CEESTATUS
AS J1
END
TABLE FILE ACTIVEPOP
PRINT
ACTIVEPOP.PRD_DATE AS 'PRD_DATE'
ACTIVEPOP.EMP_SSN AS 'EMP_SSN'
ACTIVEPOP.PENSION_PLAN_NBR AS 'PENSION_PLAN_NBR'
ACTIVEPOP.EMPLOYEE_STATUS_CODE AS 'EMPLOYEE_STATUS_CODE'
ACTIVEPOP.BATCH_TERM_PROCESS_PENDING_IND AS 'BATCH_TERM_PROCESS_PENDING_IND'
ACTIVEPOP.PAYMENT_FREQUENCY AS 'PAYMENT_FREQUENCY'
ACTIVEPOP.BENEFIT_PAYMENT_OPTION AS 'BENEFIT_PAYMENT_OPTION'
CEESTATUS.ELIGIBILITY_STATUS_CODE AS 'ELIGIBILITY_STATUS_CODE'
CEESTATUS.GI_EMPLOYEE_STATUS_CODE AS 'GI_EMPLOYEE_STATUS_CODE'
ON TABLE HOLD AS ACTIVEPOP2
END
DEFINE FILE ACTIVEPOP2
CNTR/I8= WITH PRD_DATE = 1;
END
TABLE FILE ACTIVEPOP2
SUM
TOT.ACTIVEPOP2.EMP_SSN
ACTIVEPOP2.PENSION_PLAN_NBR AS 'Plan Code'
CNT.ACTIVEPOP2.EMP_SSN AS '# of Emps'
CNTR
COMPUTE PERCENT/D6.2% = (C3/(C1/C4))*100;
BY PRD_DATE RECOMPUTE
BY ACTIVEPOP2
END
BY ACTIVEPOP2.PENSION_PLAN_NBR NOPRINT
WHERE ACTIVEPOP2.ELIGIBILITY_STATUS_CODE NE 'D'
WHERE ACTIVEPOP2.GI_EMPLOYEE_STATUS_CODE NE 'D'
ON TABLE PCHOLD FORMAT EXL2K
END
This message has been edited. Last edited by: Kerry,
Production - 7.6.4 Sandbox - 7.6.4
November 04, 2008, 03:36 PM
Francis Mariani
Perhaps using WITHIN in a PCT calculation will do what you require.
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
November 04, 2008, 04:17 PM
ColdWhiteMilk
TABLE FILE ACTIVEPOP2
SUM
ACTIVEPOP2.PENSION_PLAN_NBR AS 'Plan Code'
CNT.ACTIVEPOP2.EMP_SSN AS '# of Emps'
PCT.EMP_SSN/D6% WITHIN ACTIVEPOP2 AS 'Pct%'
BY ACTIVEPOP2.PENSION_PLAN_NBR NOPRINT
ON TABLE RECOMPUTE
Gives me:
(FOC282) RESULT OF EXPRESSION IS NOT COMPATIBLE WITH THE FORMAT OF FIELD: EMP_SSN
Production - 7.6.4 Sandbox - 7.6.4
November 04, 2008, 04:34 PM
GinnyJakes
How about PCT.CNT.
TABLE FILE EMPLOYEE
SUM CNT.EMP_ID
PCT.CNT.EMP_ID
BY DEPARTMENT
END
JOIN CLEAR *
JOIN
ACTIVEPOP.EMP_SSN
IN ACTIVEPOP TO ALL CEESTATUS.EMP_SSN
IN CEESTATUS
AS J1
END
TABLE FILE ACTIVEPOP
PRINT
ACTIVEPOP.PRD_DATE AS 'PRD_DATE'
ACTIVEPOP.EMP_SSN AS 'EMP_SSN'
ACTIVEPOP.PENSION_PLAN_NBR AS 'PENSION_PLAN_NBR'
ACTIVEPOP.EMPLOYEE_STATUS_CODE AS 'EMPLOYEE_STATUS_CODE'
ACTIVEPOP.BATCH_TERM_PROCESS_PENDING_IND AS 'BATCH_TERM_PROCESS_PENDING_IND'
ACTIVEPOP.PAYMENT_FREQUENCY AS 'PAYMENT_FREQUENCY'
ACTIVEPOP.BENEFIT_PAYMENT_OPTION AS 'BENEFIT_PAYMENT_OPTION'
CEESTATUS.ELIGIBILITY_STATUS_CODE AS 'ELIGIBILITY_STATUS_CODE'
CEESTATUS.GI_EMPLOYEE_STATUS_CODE AS 'GI_EMPLOYEE_STATUS_CODE'
WHERE CEESTATUS.ELIGIBILITY_STATUS_CODE NE 'D'
WHERE CEESTATUS.GI_EMPLOYEE_STATUS_CODE NE 'D'
ON TABLE HOLD AS ACTIVEPOP2
END
-*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
-* Final - Active Population - Summary
-*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
TABLE FILE ACTIVEPOP2
SUM
ACTIVEPOP2.PENSION_PLAN_NBR AS 'Plan Code'
CNT.ACTIVEPOP2.EMP_SSN AS '# of Emps'
PCT.CNT.ACTIVEPOP2.EMP_SSN AS '# of Total'
BY ACTIVEPOP2.PENSION_PLAN_NBR NOPRINT
ON TABLE PCHOLD FORMAT EXL2K
END
This message has been edited. Last edited by: ColdWhiteMilk,
Production - 7.6.4 Sandbox - 7.6.4
November 10, 2008, 03:51 PM
ColdWhiteMilk
In the line:
PCT.CNT.ACTIVEPOP2.EMP_SSN AS '# of Total'
The result displays as "21.00". Would I use the stylesheet to make that display as "21.00%"?
Production - 7.6.4 Sandbox - 7.6.4
November 10, 2008, 04:06 PM
GinnyJakes
Put a slash after the EMP_SSN with the format that you want: EMP_SSN/D6.2%.