How do I get a value attached to a text on a dropdown list?

[otter]

I need to get an overall average based on the selected option in several different dropdown lists. Once I have the average the final field will reflect the text as one of the options. 

There are 3 areas that are being measured. 

Quantity, Quality and Performance

Each area will get a rating, The dropdown list will show Fails, Meets, Exceeds.

The ratings need a number value that can be used to average the areas. 

Quantity = Meets = 2

Quality = Exceeds = 3

Performance = Meets = 2

Total = 5

Avg = 2  (rounded to nearest whole)

Final rating = Meets

I have built the drop down lists. I see a value that appears to be attached but I cannot figure out how to grab the value.  I need to present this to the executive team soon. Please help me understand how this works, and yes I got it to work in Acrobat but needed other functionality only available in LC Designer. 

I am using Adobe LiveCycle Designer ES2.

Thank you!!

[Jono_Moore]

If you have assigned values to the dropdown items - on the Binding tab of the Object palette: "Specify Item Values" - those values become the rawValue for the dropdown.

So for something simple in FormCalc, on the calculate event of the Final Rating you would just add the fields together and do the math.

$ = (ddl1 + ddl2 + ddl3) / 3

[otter]

Thank you I was making it more difficult than necessary. I thought I had to create a field to reflect the value then average them. It worked like a charm.

[otter]

I spoke too soon. The adding is working fine but the averaging is not. It gives me the sum result. Acts as if the “ /3” (without the quotes of course) is not at the end of the formula.

[Jono_Moore]

Odd, it should work fine.

Is there anything else going on?

[otter]

Just wanted to let you know I was able to use your suggestion. I forgot to include the parenthesis around the sum before dividing. I am very excited, my form is functioning as is should. I hope that I don’t mess up the distribution process.

Thank you.

Jerri

[Jono_Moore]

Great! Yeah got to remember your order of operations (BODMAS/PEMDAS).