Tips for creating an audit index with rating scale.

Timothé — Tue, 21 Feb 2012 10:25:18 GMT

Hello everybody,

I’m looking for tips in creating an audit index with infopath 2010.So far I created a list of question, based on 0 to 3 scale with an N/A field.For this Ii created a 2 Option Buttons per question:

One for the N/A --> Yes/No, and one for the rating 0 to 3

So far the rating is calculated in a "read-only" TextBox like this (for 2 questions)(Q11 + Q12) / (6 - Ap11 - App12)Q11 and Q12 are the results of the rating (0 to 3) and App11 and App12 are the results of the N/A field ( Yes=0 and Yes=3) and 6 is a blocked value that is the highest achievable result in the sectionFrom what I’ve seen on forums it looks like I’m doing it “the barbarian way” and works well for 2 questions but I need to do it for a hundred. So I’m looking for a smarter way to do this but I ‘couldn’t manage to find the best way to do this. I downloaded a template form from office web site but I don’t understand how values are calculated. Template downloaded à applicant rating: http://office.microsoft.com/en-us/templates/CT010144207.aspx?av=ZIPThank you by advance for the time spent in helping me.

General

Tips for creating an audit index with rating scale.