VAT Deduction formula (1 Viewer)

[sandya]

how to use following calculation in the Query/forms

Ex:
Filed1: IncludeTax amount : 100
Filed2: VAT Tax Rate is : 14.5%

After VAT deduction W/O Tax Amount is = 87.34 ( this amount how to come directly in single formula? can anyone please replay how to use the formula in this case?

Thanks,
Sandhya.

 

[pbaldy]

Try

Amount / 1.145

 

[sandya]

its working good, but how to give a fixed formula because sometimes VAT Rate is different Like: (5% or 6% or 14.5%).

 

[pbaldy]

Use a field containing the rate.