6 Replies Latest reply: Oct 22, 2017 10:53 AM by Matthew Morge RSS

    calculating %

    Divyanshi Bansal

      I have specific group of leaders and there corresponding employees.

      Now I need to calculate there headcount and there respective % corresponding to there leaders

       

      for Headcount I m using count(ID)  // ID is the employees ID

      for % I m using count(ID)/ count(TOTAL ID)

       

      The issue I'm facing while calculating % is that I need to divide by total count corresponding there leaders not by the grand total corresponding to all the leaders.

       

      Kindly help.