Search: | |||||

| ||||

Home » Forum » Sharepoint | RSS Feeds |

Is there a way to calculate the average value of a column in a

SharePoint table? The column contains numbers obviously. Even if it

takes some sort of third-party SharePoint application.

Ideally, we are trying to duplicate the functionality of an Excel

sheet that has many different sets of data on each worksheet, with an

average of each number set in the same sheet. I know duplicating this

exactly is either impossible or very hard, but that is kinda the target.

Sort of. Create a view, make sure the column to be averaged is included.

At the bottom of the view definition, in the Totals section, select the

column, and select the Average option.

The view will display the average, but the caveat is that it will only

display the average of the items displayed on the page. So if you have

1000 items in your list, and the view only displays 100 items at a time,

the average will be for those 100 items.

Thanks for your answer, but I forgot to mention that I also wish to

graph the averages of the columns if possible. Sorry I didn't mention

it earlier. Your solution doesn't allow me to graph them.

I'm trying to use the PivotChart graph webpart, but it won't work.

Does anyone know of a graphing webpart that would graph the average

values of columns in a table?

I found out how to do what I wanted. I did not know about the Office

Spreadsheet web part, and I found using that in conjunction with the

PivotChart works nicely.

Look at the Totals section of any List View. It provides aggregates like

Count, Min, Max, Avg, etc. based upon the datatype of each column in the

view.

Didn't find what you were looking for?
Find more on How do I calculate column averages?
Or get search suggestion and latest updates.

Related Topics:

- Calculating average from column of multiple list
- SharePoint - Column Averages
- Average a calulated column
- Average Calc on multiple columns
- doing "lookups" to return the value of more than one column
- Using calculated columns in content types
- Date Operators for calculated fields in list columns
- WSS V2 Calculated Column
- MOSS, moss 2007, search scope with a calculated site column
- Getting a calculated Column from a list
- Calculated Fields and the ID Column
- Item ID in Calculated Columns
- Problems searching in a calculated column in a data view web part
- Calculated column problem
- More on calculated columns
- Calculated Column Formatting
- Calculated Columns in Lists
- Using the file namd in a calculated column
- Calculated Column Output HTML
- Calculated Column Begin Event List
- Trying to create a sign-up list using calculated columns
- Calculated column formula
- System generated columns are not seen while creating calculated
- Calculate column misssing in Total category
- Field is not available in selection box for calculated column