Hi,
I have a Text Label that takes the value of a dropdown box in a form and assigns it a certain value based on the selection:
Text(Switch( ValueCount.Selected.Value, "0-5", 1, "6-50", 2, "51-100", 3, "100+", 5, 0), "0")
However, if the dropdown has multiple values, I would like them to be added together. So if "0-5" with a value of 1 is selected and "100+" with a value of 5 is selected, then the text label displays 6 rather than the most recently selected item.