InfoPath Dev

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.

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?

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