Expression in Report returning incorrect $

[Moxioron]

Hello.

I have a count and a sum expression in a report that are giving me conflicting results.

I have one transaction for $5,000 that meets the criteria below.

The count appears to be working fine:
=Count(IIf([Product]="Business Platinum Points" And [Merchant SIC] In ("4","7","6"),0))

However, the sum returns $5,238. There is no transaction in my table for that dollar amount that meets that criteria:
=Sum(IIf([Product]="Business Platinum Points" And [Merchant SIC] In ("4","6","7"),[Transaction Amount],1))

What could/would cause that? Thank you.

 

[plog]

It would be caused by the 238 records that don't meet the criteria.

Change the 1 to a 0.

 

[Moxioron]

Thank you.