Conditional field

[troutstudio]

In FMP 11, I want to make a field which affects the behaviour of another. Specifically, I have a table for income tax which includes a calculation field which automatically calculates the amount of GST (sales tax). So total in field B is 10% of field A. However, some income does not attract sales tax. I have made a field C with a drop down menu that will allow a choice of type of income - taxable or not. How can I set the database up so that choosing Taxable results in the normal calculation; and choosing Not Taxed results in a null value? I have tried Case and Validate but not getting anywhere. Thanks for your help - it's much appreciated.

[Lee Smith]

Calculation for field B (field type is Number)

Case ( Field C = "Taxable" ; Field A * .10)

HTH

Lee

[troutstudio]

Thanks so much Lee. Very nice of you. It works and I also learnt from the tip.