vat calculation

[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.

 

[Michel Walsh]

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

 

[John Spencer 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

 

[Lez]

Cheers Guys,

That work fine.

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.