The reason behind this is because in the Transaction Saved Search logic, the Quantity field is not treated as a Numeric data type and therefore would not consider the integer sign in the latter field.
In order to pull up information based by the integer sign; convert the Quantity field to a Numeric data type. To do this, add another filter that sets the integer sign validation.
Example: Criteria tab>Standard subtab>Filter column: Quantity = is less than 5
Add a filter under: Criteria tab>Standard subtab>Filter column: Formula (Numeric) | Formula: {quantity} | Formula (Numeric) = not less than | Value = 5
No comments:
Post a Comment