report2000
Technical User
Hello,
I am writing a report using a simple query:
Select ComapnyID, ComapnyName, Average(Salary), NbrOfEmployees from Company table.
I would like to replace Average(salary) with "*" if NbrOfEmployees is less than 5.
Here is my formula:
if Sum ({@NbrOfEmployees)<5
then '*'
else
totext(Average{Salary})
I am grouping by CompanyID.
I am getting the same result for every single record.
Please help
I am writing a report using a simple query:
Select ComapnyID, ComapnyName, Average(Salary), NbrOfEmployees from Company table.
I would like to replace Average(salary) with "*" if NbrOfEmployees is less than 5.
Here is my formula:
if Sum ({@NbrOfEmployees)<5
then '*'
else
totext(Average{Salary})
I am grouping by CompanyID.
I am getting the same result for every single record.
Please help