Value list-linked calculation
I want to transfer some functions used in Excel to FM.
In Excel, I have a drop-down. Each choice selects a different calculation. I'd like a similar function in FM but am not sure what the approach would be to get the equivalent functionality.
Related to this, some calculations rely and common values, eg. weight. In Excel, it is most convenient to make 'weight' a named range so that when 'weight' appears in a calculation, the value in the named range is looked up by the calculation. In FM do you have to have a field for each such value? Or is there a similar 'named range' method?