4 Replies Latest reply: Jul 25, 2017 9:41 AM by Michael Ostrovsky RSS

    Average without zero values

    Michael Ostrovsky

      Hi, the question is probably simple, but ...

      There are workers and the number of transactions they have сommitted, and there are departments where they work. I need to make the average number of transactions for the department, this is not difficult to do. I do it like this:

      Sum (count of transactions) / count (distinct (Worker)))

      And everything works, but not the way i need to. I do not want to take into  my "average" workers who have't committed any transaction at all. I do not understand where I have to set an exception..

       

      I have found a lot in a forum, but it does not work.

      I will be very grateful for any help.