Sharepoint Services

Jquery and Sharepoint for Totals and Averages for List Views

// April 29th, 2009 // Uncategorized

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

Warning: implode() [function.implode]: Invalid arguments passed in /home/hshare27/public_html/wp-content/plugins/devformatter/devgeshi.php on line 100

The joys of Sharepoint and JQuery! Ive been blown away by JQuery recently and been using it a lot in my personal websites. I needed to see whether i could use it within Sharepoint. That’s when i came across http://www.endusersharepoint.com/. I would like to thank and give credits to Paul Grenier for the following Totals value for a column on a view.

I needed a way to the total per group in a view which contained groups and be able to find their average too! The column that needed totaling is a “Calculated column” which normally presents Sharepoint a problem. Luckily i came across this this post to help me.

I’ve extended it slightly to allow the AVG to be found too!

Please note, your totals column has to be the last column shown in your view
Here’s how:

1) On your view page add in a content editor webpart

2) In the content editor webpart, click the Source Editor…

3) Add the following code:

 xhtml | 
 copy code |
?
 
01
 
02

60