Working with negative numbers.

  • Thread starter Thread starter Bunky
  • Start date Start date
B

Bunky

This is actually multiple questions. Here is the situation. I have a table
that provides me with the Forecasted number of calls and the actual number of
calls. I then have to divide the number forecasted by the actual to get a
variance percentage. If the number forecasted is lower than the actual, I
would have a negative variance. And conversely is the number forecasted is
higher than the actual, the variance is positive. Then I have to examine
each variance and if it is greater than a negative 15% or Greater than a
Positive %, I have to do some math and total the numbers for each group.

Ideas are always welcome!
 
This is actually multiple questions.  Here is the situation.  I have a table
that provides me with the Forecasted number of calls and the actual number of
calls.  I then have to divide the number forecasted by the actual to get a
variance percentage.  If the number forecasted is lower than the actual, I
would have a negative variance.  And conversely is the number forecasted is
higher than the actual, the variance is positive.  Then I have to examine
each variance and if it is greater than a negative 15% or Greater than a
Positive %, I have to do some  math and total the numbers for each group.

Ideas are always welcome!
Click to expand...

Where's the question?

Keven Denen
 
How silly of me! My problem is trying to identify the positive and negative
percentages in a query. ie
iif([Varprcnt]<'-.15',1,0) gives me an error condition. I think if I can
get over this hurdle, I will be ok.

Thanks
 
Try testing against a number and not a text string

iif([Varprcnt]<-.15,1,0)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
How silly of me! My problem is trying to identify the positive and negative
percentages in a query. ie
iif([Varprcnt]<'-.15',1,0) gives me an error condition. I think if I can
get over this hurdle, I will be ok.

Thanks

CompGeek78 said:
Where's the question?

Keven Denen
Click to expand...
Click to expand...
 
Back
Top