1 Reply Latest reply on Jul 3, 2013 5:51 AM by brian.mcaulay

    How to Count New Customers with Sales Greater than $0.00

    Kevin Purcell

      Hello,

       

      I am trying to write a formula based on new customer registrants joined to sales history that would give me a unique count of customers [CustKey] that has made a purchase.  I would like to be able to make a simple graph of these customer by date establish month that would show # of unique customers register [New Customers], # of unique customer who purchased and what percent activated which would be purchasers / total number of customers registered.

       

      I have attached a sample package if that would assist.

       

      Any help would be greatly appreciated as all of the formulas I have tried returns total number of customers but not the number of customers who have purchased.

       

      Regards,

       

      Kevin