Hi

I have just created a quick test for you.  custom list with column called "Quantity" which is number type.

Nintex forms:

• add calculated value
• double click to configure
• formula builder
• select quantity from named controls * 29.99
• published
• works as expected

Hmm it works, but there seems to be a different error on the form.  Any ideas how to debug it?

What error is there?

What type of field is your "FIELDNAME"?

are you sure the error is to do with this calculated field?

No, i am not sure it has something to do with the calculated fields because they look right.  The error is "function expected".  The filed is a text field.

Thanks,

Jennifer

so you're trying to calculate a number with a string value?

OK when I make my quantity field a single line of text field, I get #Value!

Why is your field that you will be using in a calculation of type string?

I have a text field called ChildrenExtraTickets that is a text field and i have a formula calculated in a calculated field next to it that does the math

I found the issue; there was a rule i was using to display something.

Thanks for all the suggestions!
Jennifer

OK so the issue wasn't the calculated field after all?

Pleased you've sorted it.

No it wasn't.  I guess that is what happens when you make too many changes at once and then test it.  Hopefully I learned my lesson...this time.

Thanks for all the suggestions!

Jennifer