Modifying the Retention Report

The Retention Report is a modified version of the Policy List Report that calculates policy count per status code, estimated premium, policies lost, lost policy estimated premium, and policy retention in the Major Sort and Report Footer sections.

If you have modified the Retention Report and want to restore the original Retention Report, contact Applied Support to reinstall the report. Do not perform the Revert to Default Report action, as it reverts the Retention Report to the Policy List report.

These calculations rely on the following Status Codes from Policy Status Configuration:

• CAN: Cancelled – General
• CIR: Cancelled – Insured Request
• CNP: Cancelled – Non-Payment
• CRW: Cancelled – Rewritten

If your organization does not use these specific codes, or if you use them for different purposes, you must modify the report to use your own codes in the calculations. Determine your organization’s equivalent for each of these codes before proceeding.

The calculations themselves are transparent in the report layout, and only their results are visible. Follow the instructions in this article to locate the calculation fields in the Major Sort and Report Footer sections and then update them to use your organization’s Status Codes.

Depending on which codes differ, you must update the line status codes for some or all of the following 16 fields on each report layout:

• Total1, Total5, Total18, and Total22 use the CAN code by default.

  Total/sum of Estimated Premium for policies with CAN status

  Total/sum of policies with CAN status

  Sum of Estimated Premium for policies with CAN status

  Count of policies with CAN status

• Total2, Total6, Total17, and Total21 use the CIR code by default.

  Total/sum of Estimated Premium for policies with CIR status

  Total/sum of policies with CIR status

  Sum of Estimated Premium for policies with CIR status

  Count of policies with CIR status

• Total3, Total7, Total16, and Total20 use the CNP code by default.

  Total/sum of Estimated Premium for policies with CNP status

  Total/sum of policies with CNP status

  Sum of Estimated Premium for policies with CNP status

  Count of policies with CNP status

• Total4, Total8, Total15, and Total19 use the CRW code by default.

  Total/sum of Estimated Premium for policies with CRW status

  Total/sum of policies with CRW status

  Sum of Estimated Premium for policies with CRW status

  Count of policies with CRW status

To modify the Retention Report layout to use your organization’s line status codes, do the following:

1. Access the Reports/Marketing area.

   To access the Reports/Marketing area from the Home screen, do one of the following:

   • Click Reports/Marketing on the navigation panel.
   • Click Areas > Reports/Marketing on the menubar.
   • Click the down arrow next to Home on the options bar and select Reports/Marketing.

   To access Reports/Marketing from another area of the program, do one of the following:

   • Click Home > Reports/Marketing on the menubar.
   • Click the down arrow next to Home on the options bar and select Reports/Marketing.
2. The My Reports list defaults when the Reports/Marketing screen opens. Click Policy on the navigation panel or click My Reports on the view filter and select Policy.
3. Click the Retention Report.
4. Do one of the following:
• Click the Edit button .
• Double click the report.
5. Click Layouts on the navigation panel to update the report layout.
6. Select the Retention Report – Company layout. You will also need to repeat these steps to make the same updates to the Retention Report – Producer layout.

If the Multilingual Reports option is enabled in Regional Settings Configuration, select the Language you are updating from the dropdown menu in the Detail section. You must repeat these steps for each Language in which you will generate the report. If Multilingual Reports is not enabled, you can only update the layouts in your enterprise’s Primary Language.

7. Do one of the following:
• Click the Edit button beside the Layouts list.
• Double click the layout.
8. The Output Builder lists all of the fields on the layout. Select Total1 in the Fields dropdown menu.

9. With the Total1 field selected, click the ellipsis (…) button to modify the formula.

10. The Status Code for Total1 displays above the OK button. Enter the Status Code your organization uses in place of CAN and click OK.

11. Make the same change for Total5, Total18, and Total22.
12. Total2, Total6, Total17, and Total21 use the CIR code by default. Update CIR to the Status Code your organization uses for Cancelled – Insured Request.
13. Total3, Total7, Total16, and Total20 use Line Status Code CNP by default. Update CNP to the Status Code your organization uses for Cancelled – Non-Payment.
14. Total4, Total8, Total15, and Total19 use Line Status Code CRW by default. Update CRW to the Status Code your organization uses for Cancelled – Rewritten.
15. Click File > Save All.
16. Click File > Exit.
17. Repeat these steps for the other Retention Report layout.
18. To run the report with your updated line status codes, do the following:
1. Click Modify Criteria on the navigation panel.
2. Select the Line Status criterion.
3. Add the Codes that your organization uses to the Selected list.

Adding Additional Status Codes to the Retention Report

If you need to add additional cancellation statuses to the Retention Report, you can copy the existing total field and update the Status code value to the additional code. You must perform these steps for each of the Total fields (e.g. Total1, Total 5, Total18, Total22).  

Once you have added the additional Total fields, update Formula1, Formula4, Formula9, and Formula12  to include these values.

1. With the Formula1 field selected, click the ellipsis (…) button to modify the script.
2. In the Formula Builder frame of the Script Editor, place the cursor between the closing bracket for Total8 and the closing parenthesis the entire formula, and then insert a comma and a single space so that the formula looks like this: SUM( {Total5}, {Total6}, {Total7}, {Total8}, )
3. Double click on the Report Control for the newly added Total field to insert it into the formula, so that it looks like this: SUM( {Total5}, {Total6}, {Total7}, {Total8}, {Total9})
4. Click Finish in the Script Editor.
5. Repeat these steps for the corresponding totals in Formula4, Formula9, and Formula12.

For more information on modifying the criteria, layout, and delivery options and generating the report, see Edit a Report.