9 Replies Latest reply on Feb 1, 2017 6:29 AM by Faris Ahamad M

    Counting the no.of Accounts whose sales is greater than zero

    Ayeesha Farheen

      Hi,

           Please find the snapshot below. I am trying to count the no.of Accounts whose sales is greater than zero but i am getting the count including zero sales also. Please help me to find the  count of accounts whose sales is greater than zero for each city.

      Ex: For City A, the count of Accounts whose sales is more than $0 should be 2 but i am getting 3. It is including accounts having zero sales as well.

       

       

      CityAccount SalesDate
      AAccount 1$100 16-Jan
      BAccount 2$200 17-Jan
      CAccount 3$50 18-Jan
      AAccount 1$0 19-Jan
      AAccount 5$0 20-Jan
      BAccount 6$500 21-Jan
      CAccount 7$0 22-Jan
      AAccount 8$400 23-Jan

       

       

      Please help..