I have a list with a column filled with values from 0 to 10. I need to take the average of this column and display it (maybe rounded to 1 decimal place) on another page as a kind of big, bold, overview number, so some form of styling capability is required. What would be a good way to do this? I'm comfortable with SharePoint Designer 2007.
I think what you're looking for is a KPI, which is (fortunately!) a built-in function. you'll want to:
- create a KPI list
- create a KPI which contains the average of that column
- add the webpart Dashboard > KPI Details to the display location
Here's Microsoft's page on KPIs in 2007: http://office.microsoft.com/en-us/sharepoint-server-help/create-and-publish-key-performance-indicators-kpis-HA010080027.aspx There are some limits, but your use is simple enough that it shouldn't pose a problem.