Ten Percent Difference Query

I

Irishimp23

I need a formula to put in a query showing the difference between two columns.
I have a current amount column and a previous amount column. I need to show
if the current amount column has had at least a ten percent increase or a ten
percent decrease from the previous amount column.
 
N

Neil Sunderland

Irishimp23 said:
I need a formula to put in a query showing the difference between two columns.
I have a current amount column and a previous amount column. I need to show
if the current amount column has had at least a ten percent increase or a ten
percent decrease from the previous amount column.
Click to expand...

SELECT curr_amount, prev_amount,
((curr_amount - prev_amount) / prev_amount) * 100.0 AS percent_change
FROM amounts
WHERE curr_amount
NOT BETWEEN (prev_amount * 1.1) AND (prev_amount * 9.9)
 
Top