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

    Expression to work out a percentage

      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!