3 Replies Latest reply: Oct 7, 2013 12:41 PM by Clever Anjos RSS

    If statements with multiple conditions

      I put this expression into a Text Object text expression box and says the Expression is Ok, but the correct image does not display based upon the Column2 value.  I have the Image selected from the Representation drop down in the General tab.

       

      Column1 has 8 different variables (A, B, C, D, etc) and Column2 has 1, 2, 3 which corresponds with the direction of the arrow.

       

      =if(Column1='A' and Column2=1,'qmem://<bundled>/BuiltIn/arrow_n.png',

        if(Column1='A' and Column2=2,'qmem://<bundled>/BuiltIn/arrow_e.png',

        if(Column1='A' and Column2=3,'qmem://<bundled>/BuiltIn/arrow_s.png')))