1 Reply Latest reply on Dec 21, 2016 11:46 AM by Sarah Ebreo

    Case Statement

    Nitesh Swaroop

      Hi, Can we use use two different column into a single case statement ?

        • 1. Re: Case Statement
          Sarah Ebreo

          Hi Nitesh,

           

          I don't think it is possible to have multiple expressions in a case statement. Depending on your desired result, an IF THEN statement may work. For example:

           

          IF [Field1] = x AND [Field2] = y THEN value1

          ELSEIF [Field1] = z AND [Field2] = a THEN value2

          END

           

          You can check out Logical Functions in the product guide for more information. If you need additional help, can you provide a sample packaged workbook along with detailed information about the desired behavior?

           

          Best,
          Sarah

          1 of 1 people found this helpful