Formulas

How-tos

Goal-oriented set of instructions, providing step-by-step directions to address specific real-world problems, designed for users with some prior experience

• Using the Formula editor

Explanations

Explanations serve to clarify and shed light on specific topics, contributing to a deeper understanding.

• Record context
• Measure context
• Types
• Blank values

Reference

Precise technical descriptions focusing on providing exhaustive information on key elements.

Mathematical

• ADD (+)
• CEIL
• DIVIDE (/)
• FLOOR
• MULTIPLY (*)
• POWER
• SUBTRACT (-)

Miscellaneous

• COALESCE
• LOOKUP

Date/Time

• ADDDATE
• DATE
• DAY
• DAYS
• MONTH
• NOW
• QUARTER
• TODAY
• YEAR
• YEARFRAC

Statistical

• AVERAGE
• AVERAGEX
• COUNT
• COUNTDISTINCT
• COUNTDISTINCTX
• COUNTX
• MAX
• MAXX
• MIN
• MINX
• FIRST
• LAST
• SUM
• SUMX
• ROUND

Text

• CONCAT
• LEFT
• MID
• REGEXEXTRACT
• REGEXMATCH
• REGEXREPLACE
• RIGHT
• SEARCH
• TEXT
• TEXTJOIN
• VALUE

Logical

• AND (&&)
• EQUAL (==)
• GREATER (>)
• GREATER OR EQUAL (>=)
• IF
• ISBLANK
• ISNUMBER
• LESS (<)
• LESS OR EQUAL (<=)
• NOT (!)
• NOT EQUAL (!=)
• OR (||)

Table

• ADDCOLUMNS
• FILTER
• PIVOTLONGER
• SELECTCOLUMNS
• SUMMARIZE
• UNION

Geographic

• GREAT_CIRCLE