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?