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 PerformanceEach 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 =
2Quality = Exceeds = 3Performance = Meets = 2Total = 5Avg = 2 (rounded
...