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:




      but indeed is giving unreliable results.

      Any suggestion?