pls correct the expression

[#1]

hi all

I have employee acheivemen field as below

82
72
10
15
36
50.25
87
35
66
94
45
60
31
60
35
35
67.85
20
30
56
72.5
38
55

when i am using the expression

if([Employee Acheivement] >= 35, count([Employee Number])) I am getting '-' instead of value

Pla help

[tresesco]

=Count(if([Employee Acheivement] >= 35, [Employee Number]))

[senarath]

Hi,

Try this;

=Count(if([Employee Acheivement] > 35,[Employee Number]))

thanx

[joshabbott]

This is because the first record it is looking at per the if statement is not >= 35.  Try something like:

=count({[Employee Achievement]={">=35"}} [Employee Number])

[maleksafa]

you need to evaluate the if condition inside of the aggregation function count, like what tresesco said.