I'm trying to report rolling 12 months readmit percentages by provider and overall by month. For example, in the month of June the percentage of readmits reported will be the total readmits for july14-jun15/total procedures for july14-jun15.
I used the last function to get the last 12 months score and that works for All providers, where I have a problem is when an individual provider doesn't have any procedures in the month. Those months are then skipped.
I am having trouble figuring out how to get 0's to populate for a provider when they don't have any procedures in a month.
I've searched the forum and documentation but am just stuck. I also don't think it helps that I might be attempting something that goes beyond my experience level

I'd appreciate any insight that anyone has!

Here is my code

TABLE FILE 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1
BY  0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.SERVICE_DATE_FINAL AS 'ALLSVCDATES'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS ENT_TONSILL_HOLD_DATES FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
TABLE FILE 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1
SUM
     0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.READMIT_COUNT NOPRINT
     COMPUTE MO_NM1/D12 = LAST READMIT_COUNT; NOPRINT
     COMPUTE MO_NM2/D12 = LAST MO_NM1; NOPRINT
     COMPUTE MO_NM3/D12 = LAST MO_NM2; NOPRINT
     COMPUTE MO_NM4/D12 = LAST MO_NM3; NOPRINT
     COMPUTE MO_NM5/D12 = LAST MO_NM4; NOPRINT
     COMPUTE MO_NM6/D12 = LAST MO_NM5; NOPRINT
     COMPUTE MO_NM7/D12 = LAST MO_NM6; NOPRINT
     COMPUTE MO_NM8/D12 = LAST MO_NM7; NOPRINT
     COMPUTE MO_NM9/D12 = LAST MO_NM8; NOPRINT
     COMPUTE MO_NM10/D12 = LAST MO_NM9; NOPRINT
     COMPUTE MO_NM11/D12 = LAST MO_NM10; NOPRINT
     COMPUTE MO_NM12/D12 = LAST MO_NM11; NOPRINT
     COMPUTE 12MO_READMITS/D12 = 12MO_READMITS + 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.READMIT_COUNT - MO_NM12;
     0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.TOTAL_RECORDS_COUNT NOPRINT
     COMPUTE MO_NM1_TOTAL/D12 = LAST TOTAL_RECORDS_COUNT; NOPRINT
     COMPUTE MO_NM2_TOTAL/D12 = LAST MO_NM1_TOTAL; NOPRINT
     COMPUTE MO_NM3_TOTAL/D12 = LAST MO_NM2_TOTAL; NOPRINT
     COMPUTE MO_NM4_TOTAL/D12 = LAST MO_NM3_TOTAL; NOPRINT
     COMPUTE MO_NM5_TOTAL/D12 = LAST MO_NM4_TOTAL; NOPRINT
     COMPUTE MO_NM6_TOTAL/D12 = LAST MO_NM5_TOTAL; NOPRINT
     COMPUTE MO_NM7_TOTAL/D12 = LAST MO_NM6_TOTAL; NOPRINT
     COMPUTE MO_NM8_TOTAL/D12 = LAST MO_NM7_TOTAL; NOPRINT
     COMPUTE MO_NM9_TOTAL/D12 = LAST MO_NM8_TOTAL; NOPRINT
     COMPUTE MO_NM10_TOTAL/D12 = LAST MO_NM9_TOTAL; NOPRINT
     COMPUTE MO_NM11_TOTAL/D12 = LAST MO_NM10_TOTAL; NOPRINT
     COMPUTE MO_NM12_TOTAL/D12 = LAST MO_NM11_TOTAL; NOPRINT
     COMPUTE 12MO_TOTAL_RECORDS/D12 = 12MO_TOTAL_RECORDS + 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.TOTAL_RECORDS_COUNT - MO_NM12_TOTAL;
     COMPUTE 12MO_PCT/D12.5% = 12MO_READMITS / 12MO_TOTAL_RECORDS;
     COMPUTE 12MO_PCT2/D12.5% = 12MO_PCT;
     COMPUTE 12MO_TOTAL_RECORDS2/D12 = 12MO_TOTAL_RECORDS;
     COMPUTE UCL2/D12.5% = 12MO_PCT2 + 2 * SQRT(12MO_PCT2 * ( 1 - 12MO_PCT2 ) / 12MO_TOTAL_RECORDS2);
     COMPUTE UCL3/D12.5% = 12MO_PCT2 + 3 * SQRT(12MO_PCT2 * ( 1 - 12MO_PCT2 ) / 12MO_TOTAL_RECORDS2);
BY  0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.SERVICE_DATE_FINAL
BY  12MO_AGO
WHERE ( 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.REPORTABLE EQ 'X' );
ON TABLE SET MISSING ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET DROPBLNKLINE OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS ENT_HOLD_LINES FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
TABLE FILE 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1
SUM
     0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.READMIT_COUNT NOPRINT  AS 'PROV_READMIT_COUNT'
     COMPUTE MO_NM1/D12 = LAST READMIT_COUNT; NOPRINT  AS 'PROV_MO_NM1'
     COMPUTE MO_NM2/D12 = LAST MO_NM1; NOPRINT  AS 'PROV_MO_NM2'
     COMPUTE MO_NM3/D12 = LAST MO_NM2; NOPRINT  AS 'PROV_MO_NM3'
     COMPUTE MO_NM4/D12 = LAST MO_NM3; NOPRINT  AS 'PROV_MO_NM4'
     COMPUTE MO_NM5/D12 = LAST MO_NM4; NOPRINT  AS 'PROV_MO_NM5'
     COMPUTE MO_NM6/D12 = LAST MO_NM5; NOPRINT  AS 'PROV_MO_NM6'
     COMPUTE MO_NM7/D12 = LAST MO_NM6; NOPRINT  AS 'PROV_MO_NM7'
     COMPUTE MO_NM8/D12 = LAST MO_NM7; NOPRINT  AS 'PROV_MO_NM8'
     COMPUTE MO_NM9/D12 = LAST MO_NM8; NOPRINT  AS 'PROV_MO_NM9'
     COMPUTE MO_NM10/D12 = LAST MO_NM9; NOPRINT  AS 'PROV_MO_NM10'
     COMPUTE MO_NM11/D12 = LAST MO_NM10; NOPRINT  AS 'PROV_MO_NM11'
     COMPUTE MO_NM12/D12 = LAST MO_NM11; NOPRINT  AS 'PROV_MO_NM12'
     COMPUTE 12MO_READMITS/D12 = 12MO_READMITS + 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.READMIT_COUNT - MO_NM12; AS 'PROV_12MO_READMITS'
     0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.TOTAL_RECORDS_COUNT NOPRINT  AS 'PROV_TOTAL_RECORDS_COUNT'
     COMPUTE MO_NM1_TOTAL/D12 = LAST TOTAL_RECORDS_COUNT; NOPRINT  AS 'PROV_MO_NM1_TOTAL'
     COMPUTE MO_NM2_TOTAL/D12 = LAST MO_NM1_TOTAL; NOPRINT  AS 'PROV_MO_NM2_TOTAL'
     COMPUTE MO_NM3_TOTAL/D12 = LAST MO_NM2_TOTAL; NOPRINT  AS 'PROV_MO_NM3_TOTAL'
     COMPUTE MO_NM4_TOTAL/D12 = LAST MO_NM3_TOTAL; NOPRINT  AS 'PROV_MO_NM4_TOTAL'
     COMPUTE MO_NM5_TOTAL/D12 = LAST MO_NM4_TOTAL; NOPRINT  AS 'PROV_MO_NM5_TOTAL'
     COMPUTE MO_NM6_TOTAL/D12 = LAST MO_NM5_TOTAL; NOPRINT  AS 'PROV_MO_NM6_TOTAL'
     COMPUTE MO_NM7_TOTAL/D12 = LAST MO_NM6_TOTAL; NOPRINT  AS 'PROV_MO_NM7_TOTAL'
     COMPUTE MO_NM8_TOTAL/D12 = LAST MO_NM7_TOTAL; NOPRINT  AS 'PROV_MO_NM8_TOTAL'
     COMPUTE MO_NM9_TOTAL/D12 = LAST MO_NM8_TOTAL; NOPRINT  AS 'PROV_MO_NM9_TOTAL'
     COMPUTE MO_NM10_TOTAL/D12 = LAST MO_NM9_TOTAL; NOPRINT  AS 'PROV_MO_NM10_TOTAL'
     COMPUTE MO_NM11_TOTAL/D12 = LAST MO_NM10_TOTAL; NOPRINT  AS 'PROV_MO_NM11_TOTAL'
     COMPUTE MO_NM12_TOTAL/D12 = LAST MO_NM11_TOTAL; NOPRINT  AS 'PROV_MO_NM12_TOTAL'
     COMPUTE 12MO_TOTAL_RECORDS/D12 = 12MO_TOTAL_RECORDS + 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.TOTAL_RECORDS_COUNT - MO_NM12_TOTAL; AS 'PROV_12MO_TOTAL_RECORDS'
     COMPUTE 12MO_PCT/D12.5% = 12MO_READMITS / 12MO_TOTAL_RECORDS; AS 'PROV_12MO_PCT'
BY  0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.SERVICE_DATE_FINAL
BY  0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.CHARGE_PROVIDER
WHERE ( 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.REPORTABLE EQ 'X' );
WHERE 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.CHARGE_PROVIDER EQ '&CHARGE_PROVIDER.(FIND 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1.CHARGE_PROVIDER IN 0_JB_OPPE_ENT_TONSILLECTOMY_CHARGE_V1).CHARGE_PROVIDER:.';
ON TABLE SET MISSING ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET DROPBLNKLINE OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS ENT_TONSILL_HOLD_BAR FORMAT FOCUS
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
MATCH FILE ENT_HOLD_LINES
  PRINT ENT_HOLD_LINES.SEG01.12MO_AGO ENT_HOLD_LINES.SEG01.12MO_PCT ENT_HOLD_LINES.SEG01.UCL2 ENT_HOLD_LINES.SEG01.UCL3
  BY ENT_HOLD_LINES.SEG01.SERVICE_DATE_FINAL
RUN
FILE ENT_TONSILL_HOLD_BAR
  PRINT ENT_TONSILL_HOLD_BAR.SEG01.PROV_12MO_PCT ENT_TONSILL_HOLD_BAR.SEG01.CHARGE_PROVIDER
  BY ENT_TONSILL_HOLD_BAR.SEG01.SERVICE_DATE_FINAL
AFTER MATCH HOLD AS ENT_TONSILL_HOLD_GR OLD-OR-NEW
END
-RUN
JOIN
LEFT_OUTER ENT_TONSILL_HOLD_DATES.SEG01.ALLSVCDATES IN ENT_TONSILL_HOLD_DATES
TO MULTIPLE ENT_TONSILL_HOLD_GR.ENT_TONS.SERVICE_DATE_FINAL
IN ENT_TONSILL_HOLD_GR TAG J1 AS J1
END
TABLE FILE ENT_TONSILL_HOLD_DATES
PRINT
     J1.ENT_TONS.PROV_12MO_PCT
     J1.ENT_TONS.12MO_PCT
     J1.ENT_TONS.UCL2
     J1.ENT_TONS.UCL3
BY  ENT_TONSILL_HOLD_DATES.SEG01.SERVICE_DATE_FINAL
BY  J1.ENT_TONS.12MO_AGO
BY  J1.ENT_TONS.CHARGE_PROVIDER
ON TABLE SET MISSING ON
ON TABLE SET PAGE-NUM OFF
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS TEST FORMAT FOCUS
ON TABLE SET STYLE *
$
ENDSTYLE
END
-RUN
-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+DQo8IS0tMS4wLS0+DQo8Um9vdCB2ZXJzaW9uPSIxLjAiPg0KICAgIDxPYmplY3Qgb2JqZWN0SWQ9IkNoYXJ0XzEiPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iTGlua2VkU29ydHMiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4NCiAgICA8L09iamVjdD4NCiAgICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iU2FtcGxlRGF0YSIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPmZhbHNlPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj41MDA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iZmllbGREaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+bGFiZWw8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0icHJlZml4RGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkFjdGl2ZV9TdHlsZV9Vc2VyX3R5cGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnBvd2VyPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFZhbHVlc1BhZ2luZyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+NDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJGb2NleGVjUHJlZmVyZW5jZXMiIHR5cGU9Ik1hcCI+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5RWRpdE1vZGVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlGb3JtYXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUhvbWVUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlRdWlja0FjY2Vzc1Rvb2xiYXJTYXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9Im1ldGFkYXRhX3ZpZXdzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19ESU1TPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlSZXNvdXJjZXNGaWVsZFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUluc2VydFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNsaWNlcnNUYWJFZGl0SW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2VyaWVzVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJpbmZvQXNzaXN0TW9kZUFsbG93ZWRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXRfbGF5b3V0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4xPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9jb21wb3NlX2Zvcm1hdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+UERGPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnRlcmFjdGl2ZU1vZGVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0icnVuT25TdGFydHVwSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImNhc2NhZGVOYW1lcyIgdHlwZT0iTWFwIi8+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCI+DQogICAgICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+VEVTVDwvRW50cnk+DQogICAgICAgIDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJtZXRhZGF0YVZpZXdBcyIgdHlwZT0iTWFwIj4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9IlRF
*-INTERNAL_COMMENT LINE#1$U1QiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPk1ldGFEYXRhVHJlZS5WSUVXX0RJTVM8L0VudHJ5Pg0KICAgICAgICA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iZW5hYmxlUHJldmlldyIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPnRydWU8L1Byb3BlcnR5Pg0KICAgIDwvT2JqZWN0Pg0KPC9Sb290Pg0K
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='INCHES';
-DEFAULTH &WF_STYLE_HEIGHT='4.21875';
-DEFAULTH &WF_STYLE_WIDTH='8.020833';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE TEST
-* Created by Info Assist for Graph
SUM TEST.SEG01.PROV_12MO_PCT AS '12 Mo Provider Rate'
TEST.SEG01.12MO_PCT AS '12 Mo All Provider Rate'
TEST.SEG01.UCL2 AS '2 Standard Deviations'
TEST.SEG01.UCL3 AS '3 Standard Deviations'
BY TEST.SEG01.SERVICE_DATE_FINAL AS 'Surgery Date'
WHERE TEST.SEG01.SERVICE_DATE_FINAL GE TEST.SEG01.12MO_AGO;
HEADING
"Post-Tonsillectomy Bleeds"
"&CHARGE_PROVIDER"
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setLineBasicStrokeType(getSeries(2),14);
setLineBasicStrokeType(getSeries(3),14);
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setUseSeriesShapes(true);
setMarkerSizeDefault(35);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=HEADING, JUSTIFY=CENTER, FONT='Trebuchet MS', SIZE=12, COLOR=RGB(66 70 73), STYLE=BOLD, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setScaleMaxAuto(getY1Axis(),false);
setTextFormatPreset(getY1Label(),2);
setGridStep(getY1MajorGrid(),0.02);
setDisplay(getO1MajorGrid(),false);
setSeriesType(0,1);
setGridStepAuto(getY1MajorGrid(),false);
setScaleMax(getY1Axis(),0.08);
setMarkerShape(getAllSeries(),2);
getLineDash (getSeries(2);
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH
 

This message has been edited. Last edited by: <Kathryn Henning>,

cl...first you need to simplify your problem, rewrite it using one of the ibi standard files, so we can understand you.
Right off, i see you're doing a match command with 2 prints...the 2nd verb has to be a SUM, in a match command.
Do you have all your providers in 1 table, and you're trying to create a rolling 12 for each of them? Is that it? there are several ways to do this...as with any focus program. but first, state your problem more succinctly, plz

Instead of using LAST LAST LAST LAST...

...you might want to look at our technique:

http://forums.informationbuild...817086676#6817086676

Susannah, my question was quite confusing, sorry! I think my brain was fried yesterday I tried finding a sample file but wasn't able to replicate my problem using one, I will continue to try though. In the meantime I will try to re-phrase and simplify my issue. Also, thanks for the tip on the MATCH command!

All my data is in one source table, I'm trying to create a rolling 12 months for each provider and then a rolling 12 month overall. Then I want to graph the individual provider rolling 12 month rate as a bar and the overall 12 month rate as a line.

Where I get stuck is when there is a month missing for a provider and a resulting gap in the data. I'm looking to learn a better way to calculate a rolling 12 months taking into consideration gaps in the data.

Dave, thanks for that link. I'm in the middle of trying out your technique and am working through step 8. I keep getting an error...

Thanks again!!

Dave, thanks for updating the link with more detail. I can now get your technique to work.
I appreciate the help!
Cara