Calculate a total by adding Constant amount to several other amount fields

This simplified notation calculation does not work. How do I fix it?

125.00 + Field1 + Field2 + Field3 + Field4

This topic has been closed for replies.

Correct answer try67

If you want to keep them you must escape them in the formula, like this:

125 + Field\-1 + Field\-2 + Field\-3 + Field\-4

Same goes for other special characters, including spaces.

Community Expert

Your simplified notation is working for me.

Ensure that are field names are spelled exactly with the same name in your simplified notation.

Also, make sure if what you are referring to not working means that you are not seeing the decimals.

If that is what you are referring to, ensure that all fields are formatted as number.

Participant

The problem was my field names had dashes (-). Once I removed those, the calculation works.

Community Expert

Ok, great !

Sign up