2 Replies Latest reply: Apr 26, 2016 12:43 PM by Nicole Smith RSS

    Expression to work out a percentage

    Patrice Veasey

      Hi All,

       

      I am trying to divide 'Count(Distinct Nominee)' by 'Sum HeadCount' to turn it into a percentage.

       

      The current expression I am trying for the divide is:

       

      Sum(Count(Distinct Nominee)/(Sum HeadCount))

       

      Could anyone please let me know where I am going wrong and what I need to correct it to? Thanks!