Crystal report formula

[dikidushi]

Hi morning,

Can someone help me create a formula for tax??? i am using accpac version 5.6 and i want to create a formula in crystal for tax, the formula must be like this, invoice total, 1.5% tax, 1% tax then invoice total adding up the invoice total with the tax totals and then final sub total. the tax amount must show on separate lines.

can anyone help pls,

thanx,

 

[dikidushi]

1) invoice total
2) 1.5% tax amount
3) 1% tax amount
4) invoice final total

 

[Charliy]

({invoice total}*.01)+({invoice total}*.015)+{invoice total}

 

[dikidushi]

Hi,

Thanx but did not work, the 1% and 1.5% tax need to show below the invoice total on separate lines then at last the subtotal,
the customers need to see what the amount of 1% and 1.5% is before adding up the final total

 

[VE]

How about this:

Total your invoice lines using insert summary

Create a formula for the 1% tax which is .01 * sum({invoice lines}) call it Tax1
Put that on the report under the summary.

Create a second formula for the 1.5% tax which is .015 * sum({invoice lines}) Call that Tax2
Put that on the report under the first tax formula.

Create a third formula which is {@Tax1} + {@Tax2} + sum({invoice lines}) and call that Grand Total and put that at the bottom of the invoice.

VE

 

[dikidushi]

Hi VE,

the formula worked fine thanx, however when i make an invoice with more than one line (item sales ) it will multiply this.
for example if there's a sales with 3 items it will add nine lines.

what am i doing wrong in the formula??????

thanx

 

[dikidushi]

Hi any help with this plssss, the formula is working fine, now i need to solve the double up of the items on the invoice

 

[Charliy]

You need to put the tax formulas in the Group Footer instead of the Detail line.

 

[dikidushi]

It is in the group footer and not the detail line