General

Re: How do I calculate an average of 14 different totals yet omit any totals with a sum of "0" from the average?

KRE30A — Thu, 04 Nov 2010 12:35:07 GMT

It worked! All I did was replace sum with AVG and it is doing exactly what I wanted.

Re: How do I calculate an average of 14 different totals yet omit any totals with a sum of "0" from the average?

Potemkine — Fri, 29 Oct 2010 01:51:58 GMT

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

Re: How do I calculate an average of 14 different totals yet omit any totals with a sum of "0" from the average?

KRE30A — Thu, 28 Oct 2010 09:07:35 GMT

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

Re: How do I calculate an average of 14 different totals yet omit any totals with a sum of "0" from the average?

KRE30A — Thu, 28 Oct 2010 09:00:34 GMT

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".

Re: How do I calculate an average of 14 different totals yet omit any totals with a sum of "0" from the average?

Jimmy — Wed, 27 Oct 2010 16:17:32 GMT

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

Re: How do I calculate an average of 14 different totals yet omit any totals with a sum of "0" from the average?

Potemkine — Wed, 27 Oct 2010 13:40:55 GMT

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

Thanks,

How do I calculate an average of 14 different totals yet omit any totals with a sum of "0" from the average?

KRE30A — Wed, 27 Oct 2010 09:05:23 GMT

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.