Average formula with null
I have 6 Formula Numeric Fields that Return a numeric number is a percent format... This is working just fine. But now I need to find the overall average for these 6 Fields that return a percent. But...
Forum Discussion
I have seen that option before, but it is not an option on any of the score items.
I little more background.. My Education Section has 14 different Text drop down questions, each question is answered "Compliant" or "Not Compliant"
I then have Formula Numeric Fields Called [Education-Compliant] and another [Education-Non Compliant].
Each of those has a formula to count up the "Complaints" and Non-Complaints:
Using this type of formula:
ToNumber([E1-1]="Compliant")+ToNumber([E1-2]="Compliant")+ToNumber([E1-3]="Compliant")+ToNumber([E1-4]="Compliant")+
ToNumber([E2-1]="Compliant")+ToNumber([E2-2]="Compliant")+ToNumber([E2-3]="Compliant")+ToNumber([E2-4]="Compliant")+
ToNumber([E3-1]="Compliant")+ToNumber([E3-2]="Compliant")+ToNumber([E3-3]="Compliant")+ToNumber([E3-4]="Compliant")+
ToNumber([E4-1]="Compliant")+ToNumber([E4-2]="Compliant")+ToNumber([E4-3]="Compliant")+ToNumber([E4-4]="Compliant")+
ToNumber([E5-1]="Compliant")+ToNumber([E5-2]="Compliant")+ToNumber([E5-3]="Compliant")+ToNumber([E5-4]="Compliant")+
ToNumber([E6-1]="Compliant")+ToNumber([E6-2]="Compliant")+ToNumber([E6-3]="Compliant")+ToNumber([E6-4]="Compliant")+
ToNumber([E7-1]="Compliant")+ToNumber([E7-2]="Compliant")+ToNumber([E7-3]="Compliant")+ToNumber([E7-4]="Compliant")