DataTile Knowledge Base
Breadcrumbs

Logical Condition on Numeric Values

Expressions Defining Numeric Conditions

DataTile provides an intuitive expression syntax to define a numeric condition that is considered True when satisfied.

These expressions are used in many places across the platform:

Syntax

  • A single number is a trivial condition assumed to be true when the variable is equal to the given value.

  • >=9 is true for all values 9 or greater.

  • 1_6 or 1:6 denotes the inclusive interval from 1 to 6. Underscore and colon notations are equivalent, but underscore avoids incorrect casting to a time interval in Excel.

  • * stands for ANY non-missing value. This expression is not relevant in some contexts.

You can combine expressions by separating them with commas.
For example, '1, 3, 11_15, >=20' evaluates to true if the value equals 1 or 3, lies between 11 and 15 inclusively, or is 20 or greater.