Takahide

If / Case Function

Discussion created by Takahide on Apr 5, 2016
Latest reply on Apr 5, 2016 by ch0c0halic

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%.

Capture.PNG

 

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.

Outcomes