I have a sales tax field that is currently calculated:
Case (ShipState="WA" or ShipState="WASHINGTON" ;Round(( SubTotal+Discount+Shipping) * .084;2); BillState="WA" or BillState="WASHINGTON" ; Round (( SubTotal+Discount+Shipping) * .084;2);0)
On Sept 1 the business moved to another county and the tax rate has changed to .086. I want to have the formala calculate based on .084 if before 9/1 and .086 if 9/1 or after.
I've tried this calculation but it isn't working:
Case (ShipState="WA" or ShipState="WASHINGTON" & InvoiceDate ? 8/31/2006;Round(( SubTotal+Discount+Shipping) * .084;2); ShipState="WA" or ShipState="WASHINGTON" & InvoiceDate ? 9/1/2006 ;Round(( SubTotal+Discount+Shipping) * .086;2); BillState="WA" or BillState="WASHINGTON" & InvoiceDate ? 8/31/2006; Round (( SubTotal+Discount+Shipping) * .084;2); BillState="WA" or BillState="WASHINGTON" & InvoiceDate ? 9/1/2006; Round (( SubTotal+Discount+Shipping) * .086;2); 0)
Can anyone help me make this work?
Thank you!
Case (ShipState="WA" or ShipState="WASHINGTON" ;Round(( SubTotal+Discount+Shipping) * .084;2); BillState="WA" or BillState="WASHINGTON" ; Round (( SubTotal+Discount+Shipping) * .084;2);0)
On Sept 1 the business moved to another county and the tax rate has changed to .086. I want to have the formala calculate based on .084 if before 9/1 and .086 if 9/1 or after.
I've tried this calculation but it isn't working:
Case (ShipState="WA" or ShipState="WASHINGTON" & InvoiceDate ? 8/31/2006;Round(( SubTotal+Discount+Shipping) * .084;2); ShipState="WA" or ShipState="WASHINGTON" & InvoiceDate ? 9/1/2006 ;Round(( SubTotal+Discount+Shipping) * .086;2); BillState="WA" or BillState="WASHINGTON" & InvoiceDate ? 8/31/2006; Round (( SubTotal+Discount+Shipping) * .084;2); BillState="WA" or BillState="WASHINGTON" & InvoiceDate ? 9/1/2006; Round (( SubTotal+Discount+Shipping) * .086;2); 0)
Can anyone help me make this work?
Thank you!