Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Seems to be working for me:
Seems to be working for me:
Use the search expression (double quotes)
=Count({$<[Value]={">=0.08"}>}[Task])
'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?
The problem was the . and ,. thanks!
So your VALUE values were text values, right ?
Not sure I understand what the problem was.