Categories and Calculations in Range
When running a query it is possible to specify more than just a single value. Categories and calculations with a numeric value can be queried to exist in a range. For example querying a range for categories, or calculations that have a numeric value can be tested for the mathematical values:
- Is equal to
- is not equal to
- Is in range
- Is less than or equal to
- is less than
- is more than or equal to
- is more than
It can also be tested against the logical
- Is empty
- Is not empty
or textually
- Contains
Results
The following screen shot shows the result of running a query against all of the item type and re-running with a range calculation.
The top half of the display shows the calculation having 14m2 up to 22.5m2, but the query Mid Floor Area limits the return to those between 15m2 and 20m2.
