Saturday, May 08, 2010

Sum on SharePoint Calculated Column

You were probably frustrated by the fact that when creating views on a WSS 3.0 or MOSS list you can't sum up or run another aggregation on calculated columns. SharePoint would let you do that on numeric columns but calculated columns won't show in the selection list.

If you create the list in a datasheet mode though, you will see the calculated columns on the list and will be able to present the total for the column.

When in a standard view, you can switch to a datasheet mode, you can define a sum cell for such a column. However, this won't be preserved in the system and will not show next time you access the view.

No comments:

Post a Comment

Enter your comment here