If a more complex rule to filter out particular rows is required, the Filter function comes in handy. It allows the use of any logical expression based on id, label, or value from the input Table - only the rows for which the expression evaluates to True will be included in the result. A basic example would be to filter only those rules where the value meets a simple rule, for example, is greater than X. The formula would then look as follows:
Only rows with Value > 8.5 are kept in the resulting Table.
It is also possible to use a rule based on a row label. See an example of formula filtering just these makes that start with letter A (1 character from the left equals “A”):
Another one which explicitly excludes the specific make (Alpina) from the output:
It is also possible to have more complex rules as long as they refer to the properties of the main Table used in the formula.
Logical operators can be used to have a rule based on both value and label, for example all makes that start with A and have values greater than X. Please note that only dot [.] is accepted as a decimal separator in Edit expression modal.
The property can also be compared to the results of other TabReference formulas. We may want to just take the rows where the value is greater than 99% of the maximum value from the same (or other) Query:
