Question about Export: Membership: Total Years

Jim Reynolds

I thought I posted this last week but didn't seem to stick. Hunh.

Anyways, I'm looking in Export for a total count of the membership years. Export: Membership: Total Years returns the number of years between the first membership and now - not the actual count of distinct years that the person was a member.  So using the attached record as an example, Total Years is 21, Times Renewed is 2, Consecutive Years is 0. The answer I want is 4. Make sense?



Does anyone know of a way in Export to get that?