Count if <=

[kryan]

Want to count all costs that are below -5000. Any easy ways to do this? The function below did not work.

if(cost<=-5000,count(cost))

[JuanGerardo · Accepted solution]

Hi @kryan, I recommend to avoid IF() function when possible. Try using set analysis instead (and it will have much better performance):

Count({<cost = {"<=-5000"}>} cost)

JG