Null Value preventing addition

  • Thread starter Thread starter Dkline
  • Start date Start date
D

Dkline

My expression is:
Expr1: IIf([SumOfProrated Transaction]=[IsNull],0,[SumOfProrated
Transaction])+IIf([SumOf03/04 Net Balances]=[IsNull],0,[SumOf03/04 Net
Balances])

What's I'm trying to get around if either value is null or blank, this
expression shows up blank. So I'm trying to persuade it that if the is null
or blank, just make it a 0 and add the other value.

The above only apparently works when BOTH have a value. If either is blank
or Null, nothing.

How can I make this work?
 
Try
Expr1: IIf([SumOfProrated Transaction]Is Null,0,[SumOfProrated
Transaction])+IIf([SumOf03/04 Net Balances]Is
Null,0,[SumOf03/04 Net Balances])

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
My expression is:
Expr1: IIf([SumOfProrated Transaction]=[IsNull],0,[SumOfProrated
Transaction])+IIf([SumOf03/04 Net
Click to expand...
Balances]=[IsNull],0,[SumOf03/04 Net
Balances])

What's I'm trying to get around if either value is null or blank, this
expression shows up blank. So I'm trying to persuade it that if the is null
or blank, just make it a 0 and add the other value.

The above only apparently works when BOTH have a value. If either is blank
or Null, nothing.

How can I make this work?


.
Click to expand...
 
How about:

Expr1: NZ([SumOfProrated Transaction], 0) + NZ([SumOf03/04 Net Balances], 0)

This is much easier than using the IIF statements.

HTH
Dale
 
Back
Top