4 Replies Latest reply: Sep 5, 2018 2:23 PM by Andrey Krylov RSS

    trouble using variables in expression editor to produce desired results

    Anil Kumar Janumpally

      Hello,

       

      I have trouble using variables in the expression editor.

       

      I have a variable named EXAMPLE_v, for this I have created alternatives which hold values (500,600,800,0)

      I have two table entry fields TABLE_field_a, TABLE_field_b

       

      What I need is when EXAMPLE_v=0, take TABLE_field_b of all Table rows

      When EXAMPLE_v !=0, take TABLE_field_b of only Table rows where EXAMPLE_v=TABLE_field_a

       

      I tried the below but it works only when EXAMPLE_v=0

       

      if($(EXAMPLE_v)=0,TABLE_field_b , if($(EXAMPLE_v)=TABLE_field_a,TABLE_field_b ))

       

      Regards,

      Anil