8 Replies Latest reply on Mar 25, 2016 8:13 PM by baytonemus

    Can a conditional produce multiple calculation formulas?

    baytonemus

      I've never attempted to write anything like this before. I hope that it's possible.

       

      I have a field that pulls from a value list including the names of six different royalty agreements. The terms of each agreement are unique, requiring different calculations. Is there a way that I can use the first field in an "If" statement, but return six different calculation formulas based on the result?

       

      I'm running FMP 14.0.5. Thanks!