Skip to Content
Former Member
Jun 27, 2016 at 10:18 AM formula is not working...


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


Could any one please provide insight onto what I am doing wrong here...?


screenshot.png (29.0 kB)