AnsweredAssumed Answered

Tax calculation question

Question asked by Snafu58 on Jun 17, 2010
Latest reply on Jun 17, 2010 by philmodjunk


Tax calculation question


Fairly new user of FileMaker Pro, trying to make changes to a database.  Using version 10, but some of the computers on the network are running version 8.5.

This is probably a very simple question about a calculation in a field.  I am trying to get a value for Provincial Sales Tax (PST) that is conditional upon province and Delivery Date.  If the province is Quebec, then the PST needs to always be the Sub Total + GST * 0.075.  If the province is Ontario, the PST needs to be the Sub Total * 0.08 if the Delivery Date is < June 1, 2010.  If the Delivery Date is after June 1, 2010 then the PST for Ontario needs to be 0.


This is what I have so far, which in my mind should work:


If ( Exact (Site Province ; "Quebec") ;
(Sub Total  + GST) * .075 or If (Exact ( Site Province;"Òntario" )  and (Delivery Date < Date ( 7; 1; 2010)) ; Sub Total * .08); 0 )


For some reason it gives me a value of 1 for PST in Quebec.  It seems to work properly for Ontario.

I'm sure I'm just missing something simple, but I just can't see it.