2 Replies Latest reply: Oct 3, 2014 11:32 AM by Jose Tos RSS

    Getting value of the value of a field

    Jose Tos

      Hi,

       

      I am facing a problem I can’t find the solution. You can see below part of an Excel I am using as mapping. The field Multiplier is a field I use in my expression to multiply the data by this Multiplier, for example:

       

      =Sum(Data * Multiplier)

       

      vDecimal is a variable I have defined in my app. The thing is that in my expression, Multiplier works if I have numeric values in my excel, as the first 3 rows, but the rows in red returns NULL. I think this is because instead of getting the value of the variable, I am getting it as a text ‘$(vDecimal)’ in the expression and I need the value of the variable. I tried a lot of formats without success.

       

      Line Number

      Ordering

      Account Code

      Multiplier

      L01000

      1

      AAAAAAAT

      1

      L01010

      2

      BBBBBBBT

      1

      L01020

      3

      CCCCCCCT

      1

      L01030

      4

      H10000000

      $(vDecimal)

      L01040

      5

      H20000000

      $(vDecimal)

      L01050

      6

      H30000000

      $(vDecimal)

       

      Appreciate any ideas, thanks!

       

      Regards,

      Jose