|
|||
|
|||
Hi.
How do I solve the following scenario in a charge report design? 3 pcs of item $1000 4 pcs of item $500 Subtotal 1 $1.500 Tax 1 (1.5%) $22.5 ( 1.5% of Subtotal 2 ) Subtotal 2 $1.522,5 ( Sum of Subtotal 1 + Tax 1 ) Tax 2 (25%) $380.625 ( 25% of Subtotal 2 ) TOTAL: $1.903,125 (Sum of Tax 2 + Subtotal 2) |
|
|||
|
|||
The case is a tax calculated on top of another tax, In the reports it can't be done in that way but what you could do instead is have single tax called 1+2 with a value that combine both taxes. This single '1+2' tax would have a value of: %26.875 and the math will work for you well.
|