Is null to add

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

I have this Expression and the part that has
In ('S',' ')It does not see null or blank cells. How Can
I make it see the null or empty cell. Records could have
S and be empty need to grab both when the apply.


Ann_SALE: Sum(IIf([TRANSFER_AGENT]<>"DST" And [TRADE_TYPE]
In ('S',' '),[WHLSLR_GROSS_AMOUNT],0))

My TRADE_TYPE FIELD has this in the criteria
In ("A","C","E","F","S","X"," ")

THANKS
 
I have this Expression and the part that has
In ('S',' ')It does not see null or blank cells. How Can
I make it see the null or empty cell. Records could have
S and be empty need to grab both when the apply.


Ann_SALE: Sum(IIf([TRANSFER_AGENT]<>"DST" And [TRADE_TYPE]
In ('S',' '),[WHLSLR_GROSS_AMOUNT],0))

My TRADE_TYPE FIELD has this in the criteria
In ("A","C","E","F","S","X"," ")

THANKS
Click to expand...

Use OR [Trade_Type] IS NULL as an additional criterion.
 
Back
Top