How to count with ">"?

[#1]

Hi there,

I need count the values are greater than 0.08.

I use the following formule but does not work:

Count({$<[VALUE]={'>=0.08'}>}[TASK])

The table is the next:

TASK	VALUE
1	0.01
2	0.1
3	0.2
4	0.08
5	0.09
6	0.01
7	-0.05
8	-0.02

Should be count the task 2,3,4 and 5. The count should be 4.

Thanks for all.

[sunny_talwar · Accepted solution]

Seems to be working for me:

[clondono]

Use the search expression (double quotes)

=Count({$<[Value]={">=0.08"}>}[Task])

[swuehl]

'Doesn't work' is not a good description of what you see and what you expect instead.

I assume you do get zero as result from your expression (well, just guessing, see above):

Have you double checked that your VALUE field values are numbers and not only text values?

[#5]

The problem was the . and ,. thanks!

[swuehl]

So your VALUE values were text values, right ?

[sunny_talwar]

Not sure I understand what the problem was.