What would be the easiest way /calculation to work out a tax percentage of 
a sub total too and then add to the total

I have four fields

<Settings::TAX> 
The use puts in a percentage taxrate as a number 
ie 10=10% or 12.5=12.5% etc

<SubTotal> 
Is a calculation adding up all other required fields and works

<TAX> 
I need to get the Percentage of <SubTotal> set by the field <settings::TAX>
seems to work sometimes.   

<Total> 
Then add tha <TAX> result with the <SubTotal> to get the <Total>. 
Got this working

It is for a simple invoicing system.
The easy and obvoius bits work but I can't seem to work out the percentage 
calculation tried everything (except the correct formula) (sure the formula 
I used worked in VB :-(  ) 

Thanx in advanced


-- 
----------------------------------------
Quantum Illusions: http://quantum.2ya.com

If you truly want to contact me click the link
http://quantum.2ya.com/email.htm

Well, 12.5% is the same as saying .125.  So the tax would be:
   SubTotal * Settings::Tax * .01

Bebop & Rocksteady wrote:
> What would be the easiest way /calculation to work out a tax percentage of 
> a sub total too and then add to the total
> 
> I have four fields
> 
> <Settings::TAX> 
> The use puts in a percentage taxrate as a number 
> ie 10=10% or 12.5=12.5% etc
> 
> <SubTotal> 
> Is a calculation adding up all other required fields and works
> 
> <TAX> 
> I need to get the Percentage of <SubTotal> set by the field <settings::TAX>
> seems to work sometimes.   
> 
> <Total> 
> Then add tha <TAX> result with the <SubTotal> to get the <Total>. 
> Got this working
> 
> It is for a simple invoicing system.
> The easy and obvoius bits work but I can't seem to work out the percentage 
> calculation tried everything (except the correct formula) (sure the formula 
> I used worked in VB :-(  ) 
> 
> Thanx in advanced
> 
> 

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 883-2846
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance

> Well, 12.5% is the same as saying .125.  So the tax would be:
>    SubTotal * Settings::Tax * .01

I could get the calculation to add it in but I couldn't get 
it to show the amount it was adding in 

Abs( SubTotal*(1 +(settings::Tax/100)))

don't figure ... I must be brain dead

Thanx




-- 
----------------------------------------
Quantum Illusions: http://quantum.2ya.com
Pegasus Mail Support Site: http://pegasus.quantum.2ya.com
Freeware Site: http://freeware.quantum.2ya.com
DATA Solutions: http://datasolutions.quantum.2ya.com

If you truly want to contact me click the link
http://quantum.2ya.com/email.htm