IIF function not working

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

Guest

The following IIF function is not working properly. It appears that some rows
will work and some will not.

IIF([12 month Sales]>[Store BI],1,0)

If 12 month sales are larger than Store BI I want it to be a 1 and if is not
larger I want it to be a 0.

Some results appear to have followed the function correcty and some have
not.
[12 month sales] is a column within the current Query that I have the IIF
function. [Store BI] is a seperate Query.

The IIF function has worked in similar situations(naming a field and
performing a simple formula), but apparently there is something worng with
this method.

Does anyone have any suggestions?
 
It may be something to do with the way the query is constructed - can you
post the query for this and for the one calculating [Store BI]?
 
Back
Top