Say you wanted to have a number of question groups, and a series of questions for each group:
You then wanted to post the average with the results in a SharePoint forms library. Sounds pretty easy right? Well, there's an interesting twist involved (as usual).
First, make sure your questions are grouped. You can view your data structure by choosing the Data Source option from the dropdown in your task pane:
Then create a new field to hold your average making sure to give it the appropriate data type:
Next click on the function button next to the default value textbox and insert an avg function:
Double-click to insert a field and choose the parent group of your questions:
Your formula should look like this:
That won't quite do though, you'll need to check the Edit XPath option to manually update it:
And append a /* to the end of your XPath query. That will tell InfoPath to average all of the numeric values in the child nodes of the selected parent:
Now that your average is set up, open your Form Options and configure your average field to be a Form Library Column (meaning it will display in SharePoint):
Then publish your form to a forms library and submit a test:
Isn't it grand? You can then configure your views to provide an overview of the information you want to see, but still have the option of drilling down into each survey response. You also have full control over the look and feel of your form, something you won't get (without FrontPage) using the out of the box surveys in SharePoint.