Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Is Sum HeadCount a field from your database? May be try this:
Count(DISTINCT Nominee)/ [Sum HeadCount]
Count(Distinct Nominee)/Sum(HeadCount)
I'm not sure what you're trying to accomplish with the outer sum...