COGZ Query – Setting Up Numerical Comparisons

Numerical Comparisons Do Not Work With Some Fields

Occasionally, when creating Queries, you can run into an issue when comparing one numeric field against another. A typical example would be comparing Inventory On Hand to Minimum Required. The Simple Query below would seem to be all that is required.

The query shown above will not work. If you have a quantity of 27 On Hand, and a minimum set to a quantity of 3, it will show as On Hand less than Minimum, doing the normal query comparison.

Creating a Working Query

To avoid this issue, click on “Compare Using Case Sensitive Matching” on the Value Screen

Your Query should now be comparing the numeric fields the way you intended!