2 Replies Latest reply on Mar 14, 2013 12:02 PM by Jackie Klein

    CASE statement with multiple expressions

    Jackie Klein

      I'm trying to do a CASE statement in a Calculated Field as follows, but it doesn't like the "is not null" part on the last WHEN line.

       

      CASE [Status]

      WHEN "Open Started" THEN IIF(ISNULL([Date]), "Open Started wo date", "Open Started w date")

      WHEN "Open Not Started" THEN IIF(ISNULL([Date]), "Open Not Started wo date", "Open Not Started w date")

      WHEN "Complete" THEN IIF(Field1] is not null, "Result1", IIF([Field2] is not null, "Result2", IIF([Field3] is not null, "Result3")))

      END