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)
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.
highest xml value given in the choice sheet from selected options is the class
Can you provide some examples? So we can try to create the formulation behind that selection.
Max xml value among the selected option will be my class for that survey.
calculations are done in the excel sheet…