Hi all, I have a calculated field which sums three other Currency type site columns.
=SUM([Total Cost-HR],[Total Cost-ICT],[Total Cost-PR]) This was working as expected and neither the columns nor content types using them have been touched. For some reason it's now showing: =SUM([#Namet-#Name],[#Name-#Name],[#Name-#Name]) If I modify the column and choose NOT to update all list columns it updates without error. But when I go to edit it again it reverts to the above. If I modify it with update all list columns set to True I receive the dreaded: *The formula refers to a column that does not exist. Check the formula for spelling mistakes or change the non-existing column to an existing column.* Before I attempt recreating the fields does anyone have any idea why this is occurring? Stack trace is little help. at Microsoft.SharePoint.SPField.UpdateSchemaXmlInWeb(String strXml, Boolean bToggleSealed, Boolean bRichText, Boolean bRevertCustomization, String strFmla, List`1 fldTitles, List`1 fids) at Microsoft.SharePoint.SPField.UpdateInWeb(Boolean bToggleSealed) at Microsoft.SharePoint.SPField.UpdateCore(Boolean bToggleSealed) at Microsoft.SharePoint.ApplicationPages.ManageFieldPage.UpdateFieldWithPropertiesFromXml(SPField fld, String strXml) at Microsoft.SharePoint.ApplicationPages.ManageFieldPage.ProcessWeb() at Microsoft.SharePoint.ApplicationPages.ManageFieldPage.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Regards, Paul
_______________________________________________ ozmoss mailing list [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
