View Single Post
  #5 (permalink)  
Old March 22nd, 2004, 04:55 PM
Steven Steven is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Unless you're summing that entire expression, it won't change the sum.
So unless you have something like
=Sum(iif([Status]<>"W",Sum([BMUSbmtbl]),-1))
it will work OK.

If you want to have nothing show up, change the -1 to Null
so you'd have:
Code:
=Iif([Status]<>"W",sum([BMUSbmTtl]),Null)

I am a loud man with a very large hat. This means I am in charge