2 Replies Latest reply: Nov 4, 2014 10:53 AM by Erik Furlanis RSS

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

      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!