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.