Use of Variables in expressions

[alwinsch]

  Hi all,

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?

Kind regards,
Alwin

[sunny_talwar]

What does it give you?

[Gysbert_Wassenaar · Accepted solution]

Does Vgrowth contain a text value '3%' or a numeric value 0.03? It should be the latter.

[alwinsch]

thanks,

I converted it to numeric and that did the trick.