AnsweredAssumed Answered

Problems getting a field to Calculate correctly

Question asked by JimGriffiths on Jun 5, 2011
Latest reply on Jun 8, 2011 by JimGriffiths


Problems getting a field to Calculate correctly


I have been using a previous version of FM, but recently moved to v.11. I am trying to create a very simple calculation field that uses the following equation:

Contact_FN + " " + Contact_LN

Simply takes the data of my field for a contact's first name, combines it with the data from my last name field, and sticks a space in the middle. Extremely basic.

Unfortunately, my result for every record is "0" (zero), and I cannot figure out why. The calculation field is set to have the result as text.

What stupid little thing am I doing wrong?

FYI, I am having the same problem with a more-complex calculation field that uses an If/Then equation. But I figure that I'd focus on the simple field first.

Thanks for the help that anyone can provide.