Number vs price in text field

Need help
1

Hi,
I’m stuck in some calculations…

database:
table 1:
field price (type: text)

Now I want to do some basic calculations in a textfield…

input textfield is numeric…
image

I also tried to add “convert to number” or convert to text … but it doesnt work for any reason…

2

any idea? :frowning:

3

Use input fields, not text fields when possible. If not possible, use hidden input fields to do the calculations and text fields to display the results.