Recently I noticed one issue in Calculated list field. I have one big nested IF condition in the formula and I got the below error.
Error : “The formula contains a syntax error or is not supported. at Microsoft.SharePoint.Library.SPRequestInternalClass.UpdateField(String bstrUrl, String bstrListName, String bstrXML)
at Microsoft.SharePoint.Library.SPRequest.UpdateField(String bstrUrl, String bstrListName, String bstrXML)”
Resolution : We can have 8 levels of nested IF condition in MOSS 2007 calculated formula field. In my case it is around 10. The solution is split the formula into 2or 3 parts and save them in individual calculated columnes; then create another calculated column to concatenate all parts of formula back into one. This may not be the best solution, but it is a best workaround. Alternativerly, if the formula is really big use Excel
at Microsoft.SharePoint.Library.SPRequest.UpdateField(String bstrUrl, String bstrListName, String bstrXML)”
Resolution : We can have 8 levels of nested IF condition in MOSS 2007 calculated formula field. In my case it is around 10. The solution is split the formula into 2or 3 parts and save them in individual calculated columnes; then create another calculated column to concatenate all parts of formula back into one. This may not be the best solution, but it is a best workaround. Alternativerly, if the formula is really big use Excel
and push it up with excel services.
No comments:
Post a Comment