Hi everyone,

I'm looking for some help on a tax calculation.

I want to enter the net amount the person has to receive and the gross
amount should be calculated.

I want to use the calculation in a query so it can make the calculation for
each person.

Any suggestion or examples how i can make the calculations?

TIA,

Martin.

Well, what's the tax rate?  Do you have any DDL, sample data, desired
results?



Show quoteHide quote

Not sure if you're asking how to calculate the total bill for someone, but
here's the formula for that:

Total_Amount = Sub_Total * (1.0 + Tax_Rate)

Note that Tax_Rate is a fraction representing a percentage (i.e., 6% =
"0.06").  Or maybe you're asking how to calculate the amount of tax based on
the Total bill?

Tax_Amount = TotalAmount - (TotalAmount / (1.0 + Tax_Rate))

If you can supply DDL, Sample Data, Expected Results and a clearer
description of what you're trying to achieve, it will be helpful.

Show quoteHide quote

boolean programming
Creating a trigger using a cursor
JDBC client - CURSOR as OUT parameter -supported ?
Just Venting
SQL Join and Where to Put the 'ON'