Re: Calculate totals with two seperate tax rates

Anson Hidajat — Mon, 05 Dec 2011 23:15:57 GMT

Your formula can look something like this:

my:pretax + (my:pretax * (my:provtax + my:fedtax) div 100)

Calculate totals with two seperate tax rates

Sailor — Mon, 05 Dec 2011 23:05:00 GMT

Hello,

I have the following fields:

Unit Price, Provincial Tax, Federal Tax, Pre-Tax Price, Total with Tax

All in a repeating table. The tax rate changes between area so the user enters the value as a decimal (7.00). I already calculate the Pre-tax price easily, but now need to calculate a "Total with Tax" . That means I need to do the following:

=Pre-TaxPrice + (Pre-TaxPrice * ((ProvincialTax/100) + (FederalTax/100)))

How can this be written as a formula?

Code

Re: Calculate totals with two seperate tax rates

Calculate totals with two seperate tax rates