Error in expression help!

[blunckc1]

Hi guys,

Can someone help me with the following expression as I am getting a ')' expected result.

PostCode&' - '&if(count({<AgeGroup={"0-14"}>} DISTINCT PID)>10,'Over '&count({<AgeGroup={"0-14"}>} DISTINCT PID)&' Employees',Concat(Employee Name,' | '))&' - (Age Group 0-14: '&sum({<AgeGroup={"0-14"}>} Population)&')'

Thank

[sushil353]

Try this:

=PostCode&' - '&if(count({<AgeGroup={"0-14"}>} DISTINCT PID)>10,'Over '&count({<AgeGroup={"0-14"}>} DISTINCT PID)&' Employees',Concat(Employee Name,' | '))&' - '&'(Age Group 0-14: '&sum({<AgeGroup={"0-14"}>} Population)&')'

HTH

[Chanty4u]

missing her   give one more brace

Over '&count(({<AgeGroup={"0-14"}>} DISTINCT PID)&

[sunny_talwar]

May be this:

PostCode & ' - ' &

(If(Count({<AgeGroup={"0-14"}>} DISTINCT PID) > 10,

('Over ' & Count({<AgeGroup={"0-14"}>} DISTINCT PID) &' Employees'),

Concat(Employee Name,' | ')))

& ' - (Age Group 0-14: ' & Sum({<AgeGroup={"0-14"}>} Population) & ')'