This content has been marked as final. Show 2 replies
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.
Appreciate any ideas, thanks!