In SharePoint 2010 I've made a lot of Site Columns that I use in different content types. When I make a calculated column, that involves a calculation based on other columns, something goes wrong.
This is what I type in the formula box:
This is what I get after clicking "ok" and reopening the site column:
I've tried a lot of things: changing the column names, changing the order in which I made the site columns...I've searched for some features that need to be enabled/disabled. I don't know, Nothing works!
The strangest thing is, that one of the columns is accepted (
412-Cost.Mat), I haven't found any difference between this column and the other ones.
What am I missing here? Can anyone help?