Report design, with two taxes

[itognet]

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)

[Support Team]

Re: Report design, with two taxes

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.