Reference: Operators and Functions for Conditional Formatting
Syntax Rules
Basic syntax:
first-expression comparison-operator second-expression
.
Example: ([Quick Ratio] - 10) * 2 >= 19
- An expression can reference any data series in the chart, including data from an account, calculation, or custom metric. You must enclose the data series name (not code) or the calculation name in brackets. Examples:[1000 Assets],[QuickRatio]. The data series name displays in Data Settings:
- Workday evaluatesexpressions left to right; expressions in parentheses calculate first.
Comparison
Mathematical
Use mathematical operators with the expressions.