Hi,

Does anyone know how to calculate the VAT?

Yes.

It depends from wich field you have...

( price VAT included or price VAT excluded )

... and wich is the % for the VAT

I have a sub total field. When filled I would like a seperate field to automatically calculate the VAT (17.5%) of the figure in the first field.

I will then have a grand total adding both fields together hopefully.

Cheers,

VAT =

Round ( SubTotal * VATRate ; 2 )

VATrate should auto enter the rate value from a global field (or look it up from VATrates table) - rates DO change!

You should be setting VAT for each line item, not on the subtotal. The get the total VAT by summing the line items.

We have PST and GST here and they can change from time to time and from item to item.

HTH

Dave McQueen

Hi,

What's the percentage symbol in filemaker? I simply want to find 17.5% of a figure.

If all you really want to do is find 17.5% of a figure then simply multiply the figure by.175.

If however you want to find out what is the vat component on a figure that includes vat at 17.5% then the calculation would be (figure/117.5)*17.5.

You would normally round both of these calcs to 2 decimal places.

If you are just after a quick calc then the above is all well and good otherwise, beware that as comment and David Mcqueen pointed out earlier (and you seem to be ignoring) the vat rate should not be hard coded into your calcs but in fact should be a rate that is looked up in case of changes or exclusions. Don't say you weren't warned.

Phil