2 Replies Latest reply: Sep 28, 2017 7:33 AM by Charu Rausaria RSS

    Filter then Count

    shweta gupta

      Hi All,

      Need help over constructing a formula.

       

      I need to figure out 'REPEAT' customers.

      For customer to be repeat following are the conditions

      (I) Drop all the cancelled order

      (ii) After dropping all the cancelled, Count(Invoice_ID)>3

       

      Calculate Count of Customer!

       

      Thats what I have tried using: Sum(Aggr(If(status<>'CANCELLED' and Count(distinct Invoice_ID)>3,1), Contact_ID))

       

      I need to place a condition which can first filter the Non cancelled order out which i should check customer having more than 3 invoices.