InfoPath Dev

Thank you that was an easy fix.

Im reading over the suggestions you made about the auto calculating the score in the second colum of the form but im still not getting it. you most hate newbies. Im sorry to be such a pain. learning a new program without training takes a little longer.

Thank you

Sonia

Good Morning Ernesto

In each of the section that you helped me create I have in column 2 (score) depending on how well each areas does on their inspection I would give  them a score 10,5,or 0

Each section is scored separately. When I select a score I need the form to auto sum up all the sections and come up with a %rating.

How do I get the form to automatically sum up the sections and then give me a % rating?

I have attached the form

 thanks

Sonia

Hi-

First, you'll need to add the score options to the dropdowns, so that the users can select the desired score.

Then you can simply use a formula like this:

/my:myFields/my:HideShowSection_7/my:field146 + /my:myFields/my:HideShowSection_4/my:field147 + /my:myFields/my:HideShowSection_5/my:field148 etc

to get the total score.

I'm not sure what you use in your business to calculate the percentage. If 10 is the highest score, then simply divide the total sum by 10 * number of questions.

Hope this helps!