4 Replies Latest reply: Jun 27, 2017 8:46 AM by Vasiliy Beshentsev RSS

    Count active customers between 2 dates

    Guy Hombleu

      Hello,

       

      I'm trying to count the number of active customers between 2 dates to create an analysis about campagin results. In these analysis we're compairing the facts with last year, that's why im using 2 dates.

       

         

      CustomerDate
      A5-5-2016
      B5-5-2016
      C6-5-2016
      D7-5-2016
      E8-5-2016
      F9-5-2016
      G10-5-2016
      H11-5-2016
      A5-5-2017
      B6-5-2017
      I7-5-2017
      J8-5-2017
      K9-5-2017
      L10-5-2017

       

      So im trying to figure out the following calculation:

      =count ({$<Date = {">=Campaigndate<=30-05-2016"}>} DISTINCT Customer)


      The campagindate is for example 06-05-2016.

       

      But it seems like the enddate '30-05-2016' doesnt work.

      Does anyove have an idea how to solve this one?

       

      Thnx!