Discussion board where members can get started with QlikView.
I put my formula in a Variable (Vcomm).
call the result of the variable in a textbox $(Vcomm) ---> this give me a correct result
call another variable (Vgrowth) which stores the value 3%
Now I want another textbox that gives me the Vcomm + 3% growth. I do this as follows: $(Vcomm) * (1+ Vgrowth)
it does not give me an exact calculation. The result is not the Vcomm + 3%
What am I doing wrong?
Does Vgrowth contain a text value '3%' or a numeric value 0.03? It should be the latter.
View solution in original post
What does it give you?
I converted it to numeric and that did the trick.