AnsweredAssumed Answered

Value list-linked calculation

Question asked by tays01s on Dec 1, 2012
Latest reply on Jun 18, 2013 by tays01s

Title

Value list-linked calculation

Post

     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?

Outcomes