AnsweredAssumed Answered

Question about Find

Question asked by leonhart1981 on Jul 24, 2012
Latest reply on Jul 24, 2012 by philmodjunk

Title

Question about Find

Post

I tried to perform a find that will omit the balance is zero.

So I did "Find Mode" and Omit "0" on the balance field. 

But there are some records that is zero still showing. 

I have attached a snapshot for information. 

I then realized that these "0" records are visible is because theier values are 0.0026, -0.003, 0.006, 0.00379999999999902....etc.

Could anyone teach me how to edit the Find Mode to not showing the records that the balance is zero? 

 

Moreover, balance can be negative because some of them are credit notes!!!! 

Omit_zero.png

Outcomes