Re: SharePoint Calculated Column Query

Joey_86 — Mon, 15 Oct 2012 00:34:24 GMT

Awesome, thanks so much Anson, it sucks that it doesn't accept more than 30 parameters.

Re: SharePoint Calculated Column Query

Anson Hidajat — Fri, 12 Oct 2012 16:48:11 GMT

Looks like the average function only allows up to 30 parameters: http://office.microsoft.com/en-us/sharepoint-foundation-help/average-function-HA010379927.aspx

If you know it will always be 31 days, you could try adding up all the fields then just dividing by 31?

SharePoint Calculated Column Query

Joey_86 — Fri, 12 Oct 2012 04:25:09 GMT

Hi All,

This may seem a silly question but, I currently have a SharePoint list that I converted to an XSLT dataview so I can change the date format in one of the columns, this list will basically act like a dashboard but the explanation is as below:

There are currently the following columns:

- Customer

- Month (changed from 12 October 2012 to displaying as October 2012)

- SLA Target (as a numbered column)

- Columns for Days 1 - 31 (as numbered % columns)

- Monthly Total (Calculated Column)

In the 'Monthly Total', I'm needing this to calculate the average of all days, it will accept Days 1-30 but gives me an error when I add Day 31. So formula in the calculated column is:

=AVERAGE([Day 1],[Day 2],[Day 3],[Day 4],[Day 5],[Day 6],[Day 7],[Day 8],[Day 9],[Day 10],[Day 11],[Day 12],[Day 13],[Day 14],[Day 15],[Day 16],[Day 17],[Day 18],[Day 19],[Day 20],[Day 21],[Day 22],[Day 23],[Day 24],[Day 25],[Day 26],[Day 27],[Day 28],[Day 29],[Day 30])

Hope that makes sense and thanks in advance.

General

Re: SharePoint Calculated Column Query

Re: SharePoint Calculated Column Query

SharePoint Calculated Column Query