Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculating average from column of multiple list

  Asked By: Cierra    Date: Jan 25    Category: Sharepoint    Views: 5543

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>?

Share: 

 

1 Answer Found

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

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.




Tagged: