Survey123 Connect: Select_one question chooses lowest descending string value from 8 other select_one questions.

[MasonPahl1]

I have 8 categories (fields) of inspection components: each component has its own defect rating (select_one, A-E).

rating	A	A
rating	B	B
rating	C	C
rating	D	D
rating	E	E

The structure is usually (but not always ugh) summarized by the worst rating of all of the 8 components (A is best, E is worst). I have created an 'Overall_rating' field, I need it to pick to the lowest alphabetical letter of the 8 separate select_one choices. No idea where to begin. I thought of changing the choice values to integers but not sure if that makes it easier or harder. 

Thanks in advance.

[DougBrowning]

Little clunky but not too bad.   Do a concat on all the CAV values.  Then a big if statement.  If contains E, E, if contains C, C, etc.  If you just have A-E not so bad.

Hope that helps.