4 Replies Latest reply: Nov 18, 2013 6:26 AM by eunduck kim RSS

    about variable.

      now I have tables.

      among that, one is composed product, price.

                          (calculated values)

      A     100               ?

      B     200               ?

      C     300               ?

       

      so i wanna receive a variable(vSer) on Input box.

      (maybe vSer will be 1~10 number.)

       

      After received value, go to calculation.

      ex.vSer is "4".

      100*v.Ser=400

       

      <result>

      using three charts(

      1. product, price

      2. input box(variable)

      3. result (product name, 400)

       

       

       

      I need three variables(for A, B and C)

      and hope to calculate separate values.

       

      now Im using this in result (one expression of listbox)

      if(vSer1 > 0, vSer1*price), price)

      if(vSer2 > 0, vSer2*price), price)

       

      ....I know thats innocence.

       

       

      Final Result I want

      (variable input box)          (result box)

      A     4                                   A     400

      B     2                                   B     400

      C     9                                   C     2700

       

       

       

       

      * I hope checking many products at same time.

       

      thankyou