3 Replies Latest reply on Mar 17, 2016 6:33 AM by Mark Fraser

    Eliminating Double Counting Involving Dates

    Paul Ozule

      Hello,

       

      I have this data set and i'm trying to find out folks you upgraded from Silver to Gold. I have created a set for Silver members , but my issue is when i look at the results on a month to month basis i see duplicates in subsequent months following the actual month of the upgrade.  As an example i know a member upgraded in Jan this year, but i also see that member in Feb. I have begun creating a calculation, but don't know how to restrict to the first month an upgrade (No upgrade flag) occurred.  Here is my calculation so far:

       

       

      IF [Sliver Members] = [Silver Members] and [Primary Member Type Description] = "Gold" and "not sure how to structure the date calc going forward" THEN [COUNT] ELSE 0 END

       

       

      Thanks,

      Paul