April 15, 201015 yr 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.
April 15, 201015 yr Calculation for field B (field type is Number) Case ( Field C = "Taxable" ; Field A * .10) HTH Lee
April 18, 201015 yr Author Thanks so much Lee. Very nice of you. It works and I also learnt from the tip.
Create an account or sign in to comment