Calculating VAT

[cemem]

Hello. I'm sure this has been asked before, but I have searched and can't find the answer. I'm writing a simple invoicing utility but want the VAT rate to be variable. I have: tbl_invoice and tbl_vatrate. The VAT rate in the invoice table looks the rate of from the VAT table. The problem is that trying to run a query to calculate VAT returns a rounded number and I can't stop it happening. All the numbers in the query are set to currency, with the exception of VAT rate which is set to general. The numbers in the invoice table are set to currency, with the exception of VAT rate which is set to Double, General Number and 1 decimal place. It's driving me cuckoo, any ideas?

[Stephen_C]

I suspect you're probably going to need to provide us with rather more information in order for us to help. The best thing would be to provide a link to the workflow itself but at the very least tell us what programming language you are using.

 

Stephen