Re: How to Calculate instances of numerical or text values in across several Option Button Controls

Kazzahere — Fri, 16 May 2014 13:50:58 GMT

Did you ever find a resolution to this as I am trying to do something very similar? Thanks

How to Calculate instances of numerical or text values in across several Option Button Controls

Abrams25 — Fri, 25 Oct 2013 14:30:04 GMT

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!

General

Re: How to Calculate instances of numerical or text values in across several Option Button Controls

How to Calculate instances of numerical or text values in across several Option Button Controls