Hi, I am using InfoPath 2010. My scenario, I have about 8 drop-down fields, called "Scores" with choices 1-5 as display numbers, each display number represents a value, example 1(display name) = 0.67(value), 2= 1.34, so forth and so on. I am trying display the display name instead of the value. Also once that is done there is "Total Score" field that I would like to capture the values of the 8 fields and run a formula on that total score to return "Total Score" this time displaying the "Value". ( We have different values for the different fields, which are actual questions a Project Team Committee will determine the score based on the request submitted, not sure if this particular information is relevant. )
)Here is an example
Field 1 = Score 1 value 0.67
Field 2 = Score 1 value 1.33
Field 3 = Score 1 value 1.00
Field 4 = Score 2 value 3.34
Field 5 = Score 5 value 5.00
Field 6 = Score 2 value 1.34
Field 7 = Score 1 value 1.67
Field 8 = Score 4 value 6.68
Total Score = 0.67 + 1.33 + 1.00 + 3.34 + 5.00 + 1.34 + 1.67 + 6.68 / 13.667 = 1.54 (rounding up)
Any help would be greatly appreciated.