Count one column based on negative values in another column

[Jorich919]

I know I can count the number of distinct customer numbers where revenue is 0 by this expression:

count({<Revenue={0}>}DISTINCT CustomerNumber)

But I am looking to count where Revenue is less than 0 (negative), but neither of these work:

count({<Revenue<{0}>}DISTINCT CustomerNumber)

count({<Revenue={<0}>}DISTINCT CustomerNumber)

Can someone please explain why those don't work and what the correct way is to do this? How can I filter using numerical comparison operators?

Thank you!

[treysmithdev · Accepted solution]

Try this:

count({<Revenue={"<0"}>}DISTINCT CustomerNumber)

[sunny_talwar]

How about this

Count({<Revenue = {"<0"}>} DISTINCT CustomerNumber)

Or may be this if a Customer can have more than one row of Revenue....

Count({<CustomerNumber = {"=Sum(Revenue) <0"}>} DISTINCT CustomerNumber)

[Jorich919]

Thank you!!