Criteria for Report Generation pulling incorrectly

[sugarbean97]

I have two reports I create, one for merchants who have a Debit balance in
their account, another for merchants who have a Zero balance in their
account. The balances are grouped by merchant, using the amounts from a
table. Today, I received a zero balance account on the Debit report, and the
same merchant was excluded from the Zero balance report. I verified the
entries in the table did not have an additional decimal position (hence,
rounded incorrectly). Any other suggestions as to why this merchant was
placed on the incorrect report?

 

[KARL DEWEY]

Post the SQL of the query that feeds the report and sample data.

 

[Marshall Barton]

I have two reports I create, one for merchants who have a Debit balance in
their account, another for merchants who have a Zero balance in their
account. The balances are grouped by merchant, using the amounts from a
table. Today, I received a zero balance account on the Debit report, and the
same merchant was excluded from the Zero balance report. I verified the
entries in the table did not have an additional decimal position (hence,
rounded incorrectly). Any other suggestions as to why this merchant was
placed on the incorrect report?

I suspect that the balance really is a (very?) small anount.
These can be difficult to detect so try adding a calculated
test field to the query with an expression like:
Test: balance * 100000

OTOH, maybe the field has a value of Null. If so, try using
the Nz function.