Browser Forms

Re: Average of 4 fields provided that they meet different conditions (>n)

matt.steele — Fri, 18 Feb 2011 23:15:57 GMT

Thanks, Ernesto

I didn't use you solution, but it made me remember about how rules work.

I created 4 new fields, and then attached rules to each of the the original 4 fields to set the value of the the new fields to equal the values of the original fields as long as they met the criterea OR to set the new fields values to "" (blank) if the original fields did not meet the critera. Then I set the "total average" formula to average the new fields and used InfoPath's ability to ignore blank values in its calculations and viola!

Thank you for your help! : )

~Matt

Re: Average of 4 fields provided that they meet different conditions (>n)

ErnestoM — Thu, 17 Feb 2011 13:21:51 GMT

You can have multiple calculations and just display the one you want. So for example:

field1 holds calculation #1, hidden for condition A

field2 holds calculation #2, hidden for condition B

etc.

So in your case you might have field1= average of all 4 fields, and then only display this calculation if the fields all have a value greater than 50.

field2 = average of 3 fields, only displayed when the excluded fields does not have value greater than 50,

More is possible with code, but this seems like a simple way of approaching this problem codelessly.

Average of 4 fields provided that they meet different conditions (>n)

matt.steele — Wed, 16 Feb 2011 17:39:55 GMT

Program: InfoPath2010 Designer

Form: InfoPath 2007 compatible browser-enabled form

Scenario: I have a browser-enabled form in which the totals from 4 sections are averaged in a "TotalChecklistCompliance" field.

Very simple until...

It has been requested that I re-work the average so that a given field is included in the averaging formula only if it has a value greater than 50. (Well, for 3 of the fields, anyway; the criteria for the 4th field is that it must be higher than 70 to be included in the averaging)

How would I go about doing this? If only InfoPath could do a simple "AVERAGEIF" function. Or even an "IF"

Thank you!

~Matt