IF function to look for specific value in multiple values/multiple line table

[#1]

Hi all

I have two tables, linked by an SKU field. Both tables have multiple lines per SKU.

I created a pivot chart with fields coming just from table A.

I am trying to create an expression that if there is at least one entry equal to "check" in field "criteria" of table B , it shows "check"

but since there is several values in table B for each SKU, which might be either "check" or "to be checked", I end up with unreliable results.

What I am using is:

if(criteria='check','check')

but indeed is giving unreliable results.

Any suggestion?

thanks!

[Gysbert_Wassenaar · Accepted solution]

Maybe something like this: if(count({<criteria={'check'}>}SKU),'check'). If that doesn't work you'll have to post a document that demonstrates the problem.

[#3]

Hey Gysbert!

Indeed on a sample I created it was working perfectly.

But on the real data it wasn't and had me occupied for sometime; until I realised I was using the wrong bracket!

thanks!