This content has been marked as final. Show 4 replies
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.