In testing, it was determined that the Customer Open Policy Count field was including those pesky Submissions in its results.

• Policy Renewal Report Flag = A or I (Excludes Expired, Cancelled, Re-written, Renewed, Submission, Not Taken)
• Policy Status <> D (D is for Delete. Included are A = Add, C = Change)
• Policy Sub Type <> S (to exclude Submissions)
• Policy Expiration Date after today