7 Replies Latest reply: Dec 2, 2013 7:34 AM by Paul Yeo RSS

    How to passing field = BRAND1 into my expression ?

      Hi All

       

       

      Below expression working fine at TABLE A :-

       

       

      =If(Count({<BRAND+={'BECKHOFF'}>} DISTINCT BRAND) >1, 1, 0)

       

       

      The word 'BECKHOFF' if fix , unable to change.

       

       

      I have create a field = BRAND1 , and i like to make it allow user to select any brand they like. can some one share with how to modify the expression ?

       

       

      Some thing like below at TABLE B , but not working :-

       

       

      =If(Count({<BRAND+={BRAND1+}>} DISTINCT BRAND) >1, 1, 0)