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



      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 ))