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!