I am creating a survey which asks the contributor to enter a number which I have set to be a % value.  There are several questions of this type.  I expected to then be able to configure the survey to calculate the total but can not see an obvious way to do this.  Does anyone know how to do this?  I appreciate I could take it in to excel, but I wanted each contributor to be able to to see the results as they completed the survey. Do I need a workflow.  I had a look but do not have much experience with them.

Hi,

Assuming I understood what you need correctly you wish to have a "Total" calculated column that calculates several other % columns.

If so - you have 2 options for doing this (assuming normal calculated column does not do the trick for you):

1: Develop a synch event handler that on each itemadding and itemupdating will calculate in code all the other columns into a new column (make it read only so users will not see that column in new/edit forms).

 2: No-Dev solution: you can indeed open SharePoint designer and craete a custom workflow that run for each item change / created. Do the calculation you need in a workflow variable, and store the result in the "Total" column.

If I did not understand - please ellaborate further on your requierments and post again (and sorry in advanced),

Thanks,

Shai Petel,

KWizCom

---

Shai Petel (Ben Shooshan)
KWizCom SharePoint Advisor
MCTS for SharePoint, MCT
http://www.kwizcom.com