3 Replies Latest reply on Apr 25, 2018 2:24 PM by Deepak Rai

    how to make null values a part of the total

    KAREN LUNA

      Hi!

      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

      kl