The Include only active memberships in 'Memberships as of' counts checkbox only affects the 'Memberships prior to (Start), Lapsed, and Memberships as of' numbers. These totals are affected by lapsed members because of the following scenarios:

Scenario 1: If a constituent is lapsed at the beginning of the period and is dropped during the period, they are not counted in the start totals but are counted as a drop. Since the formula subtracts the dropped from the start, the numbers do not add up correctly.

Scenario 2: If a constituent is lapsed at the beginning of the period and is renewed into the same category during the period, they are not counted in the start totals but are counted in the end totals. Since the Renew Same number is not counted in the formula, the numbers do not add up correctly.

To compare the totals in the report with the 'Include only active memberships in 'Memberships as of' counts' checkbox unmarked to the report with the option marked, follow these steps:
  1. Run the Lapsed Member report for the day before the time period for the Membership Statistics by Category report (If the Membership Statistics by Category report is being run for 1/1/05 to 12/31/05, then the Lapsed Member Report would need to be run for 12/31/04)
  2. Subtract the resulting total number of Lapsed Members from the 'Memberships prior to' value on the Membership Statistics by Category report (with the box unchecked). This will give you the start value on the Membership Statistics by Category report (with the box checked).
  3. Run the Lapsed Member Report for the last day of the time period from the Membership Statistics by Category Report (In the above example, you would use 12/31/05).
  4. Subtract the resulting total number of Lapsed Members from the 'Memberships as of' value on the Membership Statistics by Category report (with the box unchecked). This will give you the 'Memberships as of' value on the Membership Statistics by Category report (with the box checked).
For additional information about how the report calculates, review What is the Membership Statistics by Category Report and how does it calculate?