vat calculation

  • Thread starter Thread starter Lez
  • Start date Start date
L

Lez

Hi Guys,

Just looking for a calculation to work out vat value of a gross figure?

I have data coming in that has tax included into the figure and need to
bring the figure back to a nett amout

I have tried (100/(100+[vat_rate]*[gross_value])) but this is not giving me
the correct value

Any suggestions welcome.
 
THe formula could be something like:


int( 100 * CDec(price_before_tax) * CDec(tax_rate)) / CDec(100)




where tax_rate is entered as 0.04 for 4%, as example.



The explicit casts to decimal numbers, CDec, allow a maximum of precision
once converted to a base 10 number.



Vanderghast, Access MVP
 
Assumption: Vat_Rate is expressed as a percentage.

Net Amount: Gross_Value / (1 + VAT_Rate)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Cheers Guys,

That work fine.


John Spencer MVP said:
Assumption: Vat_Rate is expressed as a percentage.

Net Amount: Gross_Value / (1 + VAT_Rate)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Hi Guys,

Just looking for a calculation to work out vat value of a gross figure?

I have data coming in that has tax included into the figure and need to
bring the figure back to a nett amout

I have tried (100/(100+[vat_rate]*[gross_value])) but this is not giving
me the correct value

Any suggestions welcome.
Click to expand...
Click to expand...
 
Back
Top