Skip to main content
Use this page to look up the building blocks of a formula.

​
Numbers and percentages

50% is the same as 0.5. A minus sign can make a value negative.

​
Arithmetic

  • + add
  • - subtract
  • * multiply
  • / divide
  • % remainder
  • ^ power
Example:
Power chains are evaluated from the right. Use parentheses when the order matters.

​
Comparisons

  • = equal
  • <> not equal
  • > greater than
  • < less than
  • >= greater than or equal
  • <= less than or equal

​
Logical operators

Use and, or, and not.

​
Variable names

Backticks protect names with spaces or punctuation. A short # suffix distinguishes duplicate names.

​
Segment lookups

A plain lookup inherits the rest of the current segment. Put $ after the Variable name for an absolute lookup:

​
Relative period references

An offset follows the current Date grain. In a monthly calculation, Revenue[-1] refers to the previous month.

​
Date references

​
Formula conditions

Conditions describe where a saved formula applies:
[] applies broadly across the Model. An unprefixed condition such as [Department = "Sales"] continues to match when other Dimensions are present. $[Department = "Sales"] matches exactly the named Dimension set, while $[] matches only the empty segmentation. The leading $ belongs to a saved formula condition. In an expression, an absolute Variable reference instead places $ after its name, as in Revenue$[Department = "Sales"]. Most users choose scope through the formula editor or tell Ari where the rule should apply.

​
Function calls

Write functions with their supported lowercase names:
See the function reference for the full supported catalog and argument counts.

​
Preferred spellings

Use ^, =, and <> in new formulas. Older formulas may contain **, ==, or !=; those spellings remain accepted. Use the syntax shown on this page for new formulas. If an older expression is unclear, ask Ari to explain or update it using the current supported form.