
1. Re: Can a conditional produce multiple calculation formulas?
beverly Mar 24, 2016 12:54 PM (in response to baytonemus)Use a CASE() statement instead of IF()
https://www.filemaker.com/help/14/fmp/en/html/func_ref1.32.181.html
http://help.filemaker.com/app/answers/detail/a_id/4554/~/calculationcreationtips
beverly

2. Re: Can a conditional produce multiple calculation formulas?
dtcgnet Mar 24, 2016 1:05 PM (in response to beverly)I agree with Beverly about using a Case statement. Incredibly powerful, vastly more easy to use and to read.
HOW different are the calculations? Can you let us know a bit of what the calculations might look like?

3. Re: Can a conditional produce multiple calculation formulas?
baytonemus Mar 24, 2016 1:06 PM (in response to beverly)I had considered using CASE(), but I was thrown off by...
What I think the second link you provided is suggesting is that I create six different calculation fields, then use those field names in another calculation field...?

4. Re: Can a conditional produce multiple calculation formulas?
baytonemus Mar 24, 2016 1:09 PM (in response to dtcgnet)(Price * .091) * Quantity
Product_Total * .15
...etc.

5. Re: Can a conditional produce multiple calculation formulas?
dtcgnet Mar 24, 2016 1:09 PM (in response to baytonemus)Case (
SpecialFieldThatTheUserSelected = "Option 1" ; "Put your calculation formula here if this is true" ;
SpecialFieldThatTheUserSelected = "Option 2" ; "Put your calculation formula here if this is true" ;
SpecialFieldThatTheUserSelected = "Option 3" ; "Put your calculation formula here if this is true" ;
SpecialFieldThatTheUserSelected = "Option 4" ; "Put your calculation formula here if this is true" ;
SpecialFieldThatTheUserSelected = "Option 5" ; "Put your calculation formula here if this is true" ;
SpecialFieldThatTheUserSelected = "Option 6" ; "Put your calculation formula here if this is true" ;
"None of the above applied"
)
You actually pick the type of result. It CAN be date, or text, or number, etc.

6. Re: Can a conditional produce multiple calculation formulas?
dtcgnet Mar 24, 2016 1:15 PM (in response to baytonemus)Case (
SpecialFieldThatTheUserSelected = "Option 1" ; Price * .91 * Quantity ;
SpecialFieldThatTheUserSelected = "Option 2" ; Price * .94 * Quantity ;
SpecialFieldThatTheUserSelected = "Option 3" ; Price * .78 * Quantity ;
SpecialFieldThatTheUserSelected = "Option 4" ; Product_Total * .15 ;
SpecialFieldThatTheUserSelected = "Option 5" ; Product_Total * .35 ;
SpecialFieldThatTheUserSelected = "Option 6" ; Product_Total * .05 ;
"None of the above applied"
)
Something like that would work well. If you always use Price and Quantity, and the VALUE for each option changes, then there is another option called a Let statement. It looks more daunting, but let statements are very powerful.

7. Re: Can a conditional produce multiple calculation formulas?
baytonemus Mar 24, 2016 1:18 PM (in response to dtcgnet)I think this will do the trick. I'll give it a try shortly. Thanks!

8. Re: Can a conditional produce multiple calculation formulas?
baytonemus Mar 25, 2016 8:13 PM (in response to baytonemus)Thanks for all responses! I've got everything as it should. Much appreciated.