2 Replies Latest reply on Apr 20, 2015 3:57 PM by BruceRobertson

    Common Data

    smacleod

      I need to pull out the common data between three fields.

      I am not sure how to make a calculation to do that.

      I have three fields with lists, and need to find the value(s) that match all three.

       

      Field 1:

      100

      104

       

      Field 2:

      104

      105

       

      Field 3:

      104

      109

       

      I need to have a calculation return "104"

       

      Thanks!