Math Operations not working in Confiform

Erin Smith

I have a form with 3 fields that are set to different numbers based on sections from Dropdowns. I have a 4th field that I want to be a calculation of the 3 fields above it.

I have tried setting the 4th field using a Set Value rule, as well as using a Formula field type. So the Formula field does the math and the Set Value rule sets the 4th field to the value of the Formula.

My math operation is [entry.field1] + [entry.field2] + [entry.field3]

But I keep getting the error message: 

Expression: [+ +] could not be calculated, Too many operators or functions at: +

All field types are Numeric (except the Formula field which uses the Formula field type)

I'm sure it's obvious, but what am I doing wrong?

Thanks.

Alex Medved _ConfiForms_

You need to use something like ZEROIFEMPTY function if your fields allow empty values (not compulsory fields)

ZEROIFEMPTY("[entry.field1]") + ZEROIFEMPTY("[entry.field2]")

Alex