[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 941
  • Last Modified:

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


0
tapiwab
Asked:
tapiwab
  • 3
  • 3
2 Solutions
 
svetayeCommented:
Hello,
You can use the list view settings and set to view a total "Sum" of this column.
Just enter "Modify this view" link in the "Views" dropdown and under totals where you should see the name of your column choose "Sum".
I hope it helps.
0
 
tapiwabAuthor Commented:
that doesnt work because it count number of row not adding actual numbers in the column
0
 
tapiwabAuthor Commented:
that does work because it count number of row not the actual number in the column
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
svetayeCommented:
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/
0
 
tapiwabAuthor Commented:
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
0
 
svetayeCommented:
And you can't change the promoted field during republish?
You can create a new numeric column in your form library and target your form field (in the form during the publish procedure) to this new field. But if you have a lot of existing forms it's a little bit risky.

So the simplest solution in your case is to create a new numeric column and update it to a value from the source column(that cames from infopath) using a Workflow.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now