Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
you should have the expression like this
count(if(match([ Code], 'R350','R630','W510','W630')>0,(Report)))
hi
you should have the expression like this
count(if(match([ Code], 'R350','R630','W510','W630')>0,(Report)))