This content has been marked as final. Show 3 replies
im trying to be able to count the null values,
I have the territory and the offices
i need to know how many offices did not sell anything during each month.
Then i need to divide the total of offices that did not sell anything vs the total of offices that i have
so I can know the percentage of offices that did not sell anything.
If anyone could help me it will be very much appreciated.
I attached a work wook with an example of what im trying to do.
Thanks so much for your help community