baytonemus

Can a conditional produce multiple calculation formulas?

Discussion created by baytonemus on Mar 24, 2016
Latest reply on Mar 25, 2016 by 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!

Outcomes