2 Replies Latest reply: Jul 18, 2014 10:38 AM by David Thorpe RSS

    Show Conditional with multiple Variables

      Hi all,

       

      I have a few text boxes set up that I'm using to set variables, I'm then using these variables in the Show Conditional option for certain objects. This works fine when I want to show/ hide an object based on the value of one variable, but what about if I want to show/ hide an object based on the values of multiple variables?

       

      E.g.

       

      TextBox1 sets vShowABC to 1 and vShowDEF to 0

      TextBox2 sets vShowABC to 0 and vShowDEF to 1

       

      TextBox3 sets vShow123 to 1 and vShow456 to 0

      TextBox4 sets vShow123 to 0 and vShow456 to 1

       

      Object1 has the Show Conditional Expression set to vShowABC = 1

      Object2 has the Show Conditional Expression set to vShowDEF = 1

       

      So using the text boxes I'm able to control which object is displayed on my sheet by using the Show Condition Expressions:

       

      (Object1) vShowABC = 1

      (Object2) vShowDEF = 1

       

      However, I want to create Object3 that has the Show Condition where vShowABC = 1 and vShow123 = 1. Please could someone show me the Expression syntax to make this possible?

       

      Cheers!