Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
missing her give one more brace
Over '&count(({<AgeGroup={"0-14"}>} DISTINCT PID)&
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) & ')'