Simple set analysis (if) (count)

[aaronnayan]

Hi Experts.

I need your assistance

How would i count the number of tshirts sold if they were less than 500?

So far i have

if([TshirtSaleCount]={"<500"}, count([Tshirt's sold],0)

Thank you so much

[sunny_talwar · Accepted solution]

May be this

Count({<TshirtSaleCount = {"<500"}>} [Tshirt's sold])