3 Replies Latest reply: Jul 1, 2016 3:24 AM by Sunny Talwar

# Error in expression help!

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

• ###### Re: Error in expression help!

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

• ###### Re: Error in expression help!

missing her   give one more brace

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

• ###### Re: Error in expression help!

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) & ')'