Number vs price in text field

[fok_ste]

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…

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

[fok_ste]

any idea?

[robert]

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.