1 Reply Latest reply on Jul 24, 2012 3:45 PM by philmodjunk

    Question about Find

    leonhart1981

      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

        • 1. Re: Question about Find
          philmodjunk

          You could  omit values less than 0.005.

          Or you might take a look at the calculations that are producing these values and put them inside a round function to round them to the nearest penny so that you do not have such small nearly zero amounts in this field to begin with.