tapiwab
asked on
Sum of a Single Column in Sharepoint
i have a column that is a number field in sharepoint list "Number of hours" that contains full numbers, how do i get the total hours
e.g
if the Column is: Number of Hours
16
14
11
total must display 41 not 3
e.g
if the Column is: Number of Hours
16
14
11
total must display 41 not 3
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that does work because it count number of row not the actual number in the column
If you see only a "Count" option near your column name in the "Totals' section it means that your column is not a "Numbers" column. Please re-check againg the column type.
About "Totals" from office.microsoft.com:
Totals Displays summary calculations for the columns in the view, such as: count, average, maximum, minimum. By setting the title column to Count in a document library, for example, the view will display the number of documents in the view and in the groups in the view.
The columns that are available for totals and the settings available for each column differs depending on the type of column, such as number, and the type of list or library the view is being created for.
In any case you always can show it using SharePoint Designer.
Please follow this article (it works the same way even for non calculated columns):
http://raintreestudio.wordpress.com/2010/06/21/how-to-create-a-total-of-calculated-columns-using-sharepoint-designer/
About "Totals" from office.microsoft.com:
Totals Displays summary calculations for the columns in the view, such as: count, average, maximum, minimum. By setting the title column to Count in a document library, for example, the view will display the number of documents in the view and in the groups in the view.
The columns that are available for totals and the settings available for each column differs depending on the type of column, such as number, and the type of list or library the view is being created for.
In any case you always can show it using SharePoint Designer.
Please follow this article (it works the same way even for non calculated columns):
http://raintreestudio.wordpress.com/2010/06/21/how-to-create-a-total-of-calculated-columns-using-sharepoint-designer/
ASKER
the problem is my columns where created with information from Infopath fields so after publishing the form all fields became single line of text, now i cant see sum
i will try the dataview part solution
i will try the dataview part solution
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER