Hi, I am creating discount options but I cannot figure out how to apply the sales tax of 4.5% at the discounted service total.

EX: service fee $100

discount 10%

sales tax should be $100 X 10% X 4.5% = **$4.05 **

------> but always the sales tax comes out as $4.50 which is calculated as $100 X 4.5%.

If ( Payment = "credit"; Service total + Sales Tax + Product Total + Sales Tax Product + Tip -

Case (

Promotion="10%"; Truncate (Service total * .1 ; 0) ;

Promotion="20% C"; Truncate (Service total * .2 ; 0) ;

Promotion="20% S"; Truncate (Service total * .2 ; 0) ;

0

)

)

Please help! Thank you very much.

Assuming "Sales Tax" is a calculated field, what formula do you have in there? It looks like it is Service Total * 0.045, but it should be ( Service Total - Promotion ) * 0.045.