Situation:
We need a way to evaluate a set of company products based on eight different standards. Im using InfoPath 2010
For each of the eight standards a product can score either a Zero (0), One (1), Two (2), or Three(3).
The Standards for Quality are not based on a total (think cumulative) score, instead, the standards are based on the number of instances a product recieves a particular score.
For example:
To get a "passing grade" my product cannot have more than two instances of a Zero (0) or One (1) rating across the eight different standards. This is a pass/fail standard.
So imagine my evaluator scores my product like the following (with the 0 and 1 score interchangavle): Standard 1: 0; Standard 2: 1; Standard 3: 2; Standard 4: 2; Standard 5: 2; Standard 6: 3; Standard 7: 3; Standard 8: 3 (score: One instance of 0, One instance of 1, Three instances of 2, and Three instances of 3; a passing score)
But if my evaluator scores my product like the follwoing I will have failed: Standard 1: 0; Standard 2: 1; Standard 3: 1; Standard 4: 2; Standard 5: 2; Standard 6: 3; Standard 7: 3; Standard 8: 3 (Score: One instance of 0, Two instances of 1, Two instances of 2, and Three instances of 3; a failing score)
What I have Done:
I have created eight different option button controls (one for each standard), each with Four options buttons. Each of the four option buttons returns a different number based on the score that it represents, i.e. the first option returns a 0, the second option returns a 1, the third option returns a 2, and the fourth option returns a 3.
*I could just as easily change the values from numerals to text - i.e. Zero, One, Two, Three - if that makes counting instances easier? Having a numerical value returned by the option button control is not a end-all-be-all for this situation
What I Need:
I need to show the total number of instances per numerical score (1-4). Then using the number of instances, calculate if the product passed (with no more than two instances of a 0 or 1 rating) or failed (more than three or more instances of a 0 or 1 rating).
Im not even sure where to start. Maybe use Count, maybe use CountIF - idk, I cant really find anything out there similar to my needs.
Help PLEASE! Am I making this too hard? Does InfoPath have the capability to accomplish this task? Thanks!