expression

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

I have the following expression:

Deal Types: IIf([Customer].[Payoff Date]>=[customer].[close date],"Pay
Off","New Deals")

I also want the expression to show all null values for payoff date. Where
would I put that in my expression??
 
I also want the expression to show all null values for payoff date. Where
would I put that in my expression??
Click to expand...

Assuming that you want NULL payoffdates to show as New Deals, try

Deal Types: IIf(NZ([Customer].[Payoff Date],#1/1/100#)>=[customer].[close
date],"Pay Off","New Deals")
 
Back
Top