Savana36237820a0tv

Participant

Answered

Subtraction Formula Not Working

Forum|Forum|1 year ago
April 25, 2024
1 reply
603 views

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!!!

This topic has been closed for replies.

Correct answer try67

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

Community Expert

Correct answer

Community Expert

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

Savana36237820a0tvAuthor

Participant

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