I need to count the number of names if the corresponding value is =>9000.
I wrote the following variable.
=Count([Name]) Where ([Value]>=9000)
In the below example, the answer should be 2.
But it is not working...
It returns 3, which is maximum number of names available in the object.
[Value] is string, but is turned to measurement, using the following formula
=ToNumber([Value])
Could any one please provide insight onto what I am doing wrong here...?