Subtraction Formula Not Working

[Savana36237820a0tv]

I am trying to create a calculation on a form. My fields are named Previous Job Total and Revised Job Total. I go to the calculate tab enter "Revised Job Total-Previous Job Total" under simplified field notation and nothing happens. I don't get an error message or anything. I have tried using Underscores for the spaces, all lower case, no spaces, spaces on both eds of the minus signs. I even deleted the box and put a new one in just in case. I would appreciate any insite because I am at a loss. Thank you!!!

[try67 · Accepted solution]

Special characters (such as spaces, hyphens, etc.) need to be escaped. Try this:

Revised\ Job\ Total - Previous\ Job\ Total

Alternatively, rename the fields and remove the spaces, and then you would be able to use their names directly, like this:

RevisedJobTotal - PreviousJobTotal

[Savana36237820a0tv]

Ah! Thank you! I was starting to feel crazy for not being able to do subtraction