Expression to work out a percentage

[#1]

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!

[sunny_talwar]

Is Sum HeadCount a field from your database? May be try this:

Count(DISTINCT Nominee)/ [Sum HeadCount]

[Nicole-Smith]

Count(Distinct Nominee)/Sum(HeadCount)

I'm not sure what you're trying to accomplish with the outer sum...