If and Set-analysist not same results

[Applicable88]

Hello,

i have following expression within my bar-chart:

count({$<[ Code]={"R350","R630","W510","W630"}>}Report)

Why I don't get any results with this if -statement:

=if(match([ Code], 'R350','R630','W510','W630'),(Report))

I tried wildmatch also. Not a single value showing in the chart.

Tried that as well:

if(match([ Code], 'R350','R630','W510','W630'), count (Report))

Thanks in advance.

Best

[lironbaram · Accepted solution]

hi 

you should have the expression like this 

count(if(match([ Code], 'R350','R630','W510','W630')>0,(Report)))