Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Calculating average from column of multiple list

Asked By: Cierra Navarro Date: Jan 25, 2009 Category: Sharepoint Views: 1037

I have four custom lists which are used for saving numeric data. Each
list have a four columns (A-D) for entering numeric data and one
calculated column "weighted score" with formula to compute average of
A-D.

I need to compute and display average of "weighted score" from four
lists.

One way is to use Office web component (spreadsheet) to calculate and
display average of "weighted score" but its not a good way although.

Is there any other way to get the average of columns from multiple
lists>?

Tagged:calculating average from column of multiple list

1 Answer Found

Answer #1 Answered By: Kamal Mayachari Answered On: Jan 25, 2009

There are a few ways to do this - here are the 2 that come to mind immediately:

- use 4 hidden Data View web parts (to retrieve each list average and set the
value in a hidden form field) and some custom javascript in a Content Viewer web
part to do the calculations and display the overall average
- write a custom webpart that uses either the OM or Web Services to retrieve
the values from the 4 lists and calculates overall average

The first is best if you don't want to or cannot use custom webparts. The
second is the most flexible and will have the best performance if properly
coded.

Didn't find what you were looking for? Find more on Calculating average from column of multiple list Or get search suggestion and latest updates.

Your Answer

Answer should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].

Please login to post comment

Previous: Sharepoint folders search

Next: subweb

Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.