How to Calculate Invoice TAX AMOUNT ?

[fsilva79]

I create a report with several invoices of 1 customer, example:
Customer# 123
->Invoice # 10, 20, 30 ... 70
-> each invoice has it's own sold items # ...

What I need is to Calculate the Sub_total = Sum(Item_price * Qty)
then I need the TAX Amount ... TAX_Amount = @SubTotal * 0.075

when I do this, it brings me the TAX AMOUNT of ALL the invoices, And I just need the TAX Amount of EACH invoice.

Then I need the Total for each invoice.

Please helpme out, I've been dealling with this issue for 2 days and can't solve it, please help urgent.

Thanks in advance.

Paco

 

[lbass]

Try grouping on customerID and then create a second group on invoiceID. Create your formula {@cost}:

{table.item_price}*{table.qty}

Now insert a summary on {@cost} for all groups. This will give you subtotals on invoices.

Then to get the tax, create a formula {@taxinv}:

sum({@cost},{table.invoiceID})*.075

To get the total per invoice, create a formula {@invoicetotal}:

sum({@cost},{table.invoiceID}) + {@taxinv}

-LB

 

[fsilva79]

thanks for your advice.

I'll try it.

Sounds like I need to lear more triks about grouping.

Sincerlly
Paco