4 Replies Latest reply: Apr 3, 2013 9:05 AM by Gysbert Wassenaar RSS

    count of sum of values

      Hi there,

       

      I have a set of customers with the number of transactions they performed in certain dates.

       

      I want to show in a textbox the number of ids ( unique) that have not performed any transactions and the ones that have performed at least one transaction in the entire data history.

       

      for example using the test data below i should display :

       

      # of Customers with transactions : 4 ( customers 1,2,4 and 5)

      # of Customers with no transactions : 2 ( customers 3 and 6)

       

       

      customer iddate of transaction# of transactions
      121/03/2013 0
      119/03/2013 0
      101/04/2013 1
      130/11/1999 2
      122/03/2013 0
      102/04/2013 0
      130/03/20130
      201/04/2013 0
      230/03/2013 0
      230/11/1999 0
      215/03/20130
      230/03/2013 2
      315/03/20130
      430/03/2013 0
      430/11/19993
      530/03/2013 4
      530/03/2013 4
      530/11/1999 6
      615/03/2013 0
      630/03/20130

       

       

      Thank you in advance.