InfoPath Dev

I have an evaluation form that I created that has 14 different evaluation areas in it(Planning, Budgeting, etc).  Within each of these 14 areas there are various "traits" that a person is rated of from one to 10.  As I rate each trait I get an average for the entire area being evaluated.  That evaluation total is then populated in an "Overall Evaluation" summary section which captures the final average for each evaluation area.  I then have a final score area which sums up all of the 14 averages and divides them by 14.  The problem is, is there is one evaluation area in which an individual is not rated, this total will be "0" and I need to exclude that "0" from the final score (which normally would divide all scores by 14).  This in turn, throws the average off.

 Any help would be appreciated.

Hi, I can replicate your problem can you attach your form? When you reply select option and attach your template.

Thanks,

Instead of dividing by 14, divide by count(items[. != 0])

Example of current formula:  Here is the formula -  sum(PlanningScore | BudgetingScore | TeamScore | ReportScore | CommunicationScore | Testing Score)/6

Being a novice to this, I am not quite sure how to enter what you have suggested above in that the error that I get is "Node-test expected".

Example of current formula(Note, I did not enter all 14 areas:

Here is the formula - sum(PlanningScore | BudgetingScore | TeamScore | ReportScore | CommunicationScore | Testing Score)/6

 Hi, why you don't use the function avg() instead of sum() and divide by the total ?