2 Replies Latest reply on Nov 28, 2017 10:56 AM by Jim Dehner

    % Pass rate within a category

    Kenneth Ho

      Hi,

       

      I ran into an issue where I am trying to find the passing rate (%) for sales office.  I am able to define Pass/Fail by a set of criteria, however, how would I be able to use calculate field to come up with passing rate.  For instance, my first sales office has 5 pass out of total of 8, the pass% should be 63%.  What should I do for each sales office?