Assign Land Class based on the Four Selected option

User Support Form Building
1

I want to assign the land class based on the four options selected, the XML values analyzed, and the highest among all is my land class.
aCpKUgX3PqM4cf9kZMMyxz.xlsx (7.0 KB)

2

Hi @dscndb001 and welcome back to the community!

What’s the critearia for land classes? Right now in your calculation question you only wrote calculation rather than any formula.

3

highest xml value given in the choice sheet from selected options is the class

4

Can you provide some examples? So we can try to create the formulation behind that selection.

5

Max xml value among the selected option will be my class for that survey.

6

Land Classification Sheet.xlsx (502.5 KB)
Sheet for your reference

7

calculations are done in the excel sheet…