I had no choice but to create this as a list column and then add to the list content types which has obviously resulted in breaking site-level inheritance.
Regards, Paul Noone SharePoint Farm Admin/Developer Infrastructure Team CEO Sydney p: (02) 9568 8461 f: (02) 9568 8483 e: [email protected] w: http://www.ceosyd.catholic.edu.au/ On 8 May 2013 12:49, Web Admin <[email protected]> wrote: > 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
