Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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
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