Filemaker Formula Help
I know there are a few Filemaker pros on this board, and I'm certainly not one of them. I'm hoping I can get some help with a simple formula that I can't seem to get to work.
I'm trying to use Filemaker to calculate the Canadian Goods and Services tax. (GST is 7% of the sales price of a product.)
Creating a calculation field for GST is simple enough. I create a new field named "GST" with the calculation of:
GST = 7/100 * Sales
Where I'm stumped is how I incorporate tax exempt sales (e.g. to Americans etc.).
I created a field called "GST exempt" which can be set to YES when I'm registering a tax exempt sale.
How do I tell Filemaker: "If GST Exempt = Yes, then GST = 0.00 otherwise use the "GST = 7/100 * Sales" formula?
Nothing I try seems to work.
I'm trying to use Filemaker to calculate the Canadian Goods and Services tax. (GST is 7% of the sales price of a product.)
Creating a calculation field for GST is simple enough. I create a new field named "GST" with the calculation of:
GST = 7/100 * Sales
Where I'm stumped is how I incorporate tax exempt sales (e.g. to Americans etc.).
I created a field called "GST exempt" which can be set to YES when I'm registering a tax exempt sale.
How do I tell Filemaker: "If GST Exempt = Yes, then GST = 0.00 otherwise use the "GST = 7/100 * Sales" formula?
Nothing I try seems to work.
Comments
if (GST Exempt = "Yes", 0, 7/100 * sales)
Originally posted by spotcatbug
Change the formula for GST to this:
if (GST Exempt = "Yes", 0, 7/100 * sales)
Works perfectly. Thanks.