Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Does Vgrowth contain a text value '3%' or a numeric value 0.03? It should be the latter.
What does it give you?
Does Vgrowth contain a text value '3%' or a numeric value 0.03? It should be the latter.
thanks,
I converted it to numeric and that did the trick.