3 Replies Latest reply on Sep 28, 2018 8:47 AM by Ritesh Bisht

    Complex If statements (three options)

    A Je

      I am assessing unstructured data and i have utilized reg expressions to capture that data.

       

      I want to create a calculated field that will be populated by one of the three dimensions or nothing if the three fields are null.

       

      All three of the fields w/have the same exact data if they are not blank.

       

      Essentially......

      If dimension 1 is not blank then dimension 1

      If dimension 1 is blank then dimension 2

      If dimensions 1 and 2 are blank then dimension 3

      If dimensions 1, 2, and 3 are blank then leave blank

       

      Please see attached file