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



          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?



          1 of 1 people found this helpful