Working with negative numbers.

[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!

 

[CompGeek78]

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!

Where's the question?

Keven Denen

 

[Bunky]

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

 

[John Spencer]

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

Where's the question?

Keven Denen