Calculating cost

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that contains two costs: a standard cost and an unstandard cost

I would like to calculate the difference between the two costs so that if there is + or - 15% difference, a column will flag it with an "X". So something like if it is IIF variance between the two costs >=.15, "X", is null

I know I need to use the ABS function and IIF function, but I am unsure how to put it together

Any ideas

Thanks in advance
Matt
 
Lets break this into pieces:

To calculate difference:

(UNstandardCost-StandardCost)/StandardCost

This will return a negative number.

ABS((UNstandardCost-StandardCost)/StandardCost)

This will return a positive number.

IIF(ABS((UNstandardCost-StandardCost)/StandardCost)
=.15,"X","")
Click to expand...

That will show an X for values that exceed 15% (.15)

Chris Nebinger

-----Original Message-----
I have a table that contains two costs: a standard cost and an unstandard cost.

I would like to calculate the difference between the two
Click to expand...
costs so that if there is + or - 15% difference, a column
will flag it with an "X". So something like if it is IIF
variance between the two costs >=.15, "X", is null)
I know I need to use the ABS function and IIF function,
Click to expand...
but I am unsure how to put it together.
 
Back
Top