set analysis

[pascos88]

Does someone know why it is not working?

count(distinct {<Score={'> 99'}>} CompanyName)

how I can put field > number in a set expression?

thanks

[OmarBenSalem · Accepted solution]

count(distinct {<Score={"> 99"}>} CompanyName)

[OmarBenSalem · Accepted solution]

1)count(distinct {<Score={'> 99'}>} CompanyName)

=count company that has score value = '>99'

2)count(distinct {<Score={"> 99"}>} CompanyName)

= count compnay that has score > 99