Function catalog

One page per function with examples is generated from the engine's registry and also served to agents as the MCP resource finidb://functions. Until that generator lands, this page lists the catalog by family. Names are case-insensitive. Aggregates skip blanks and propagate error values.

Logic / type

IF
AND
OR
IFERROR
EQ
NOTEQ
ISBLANK
ISLOGICAL
ISNONTEXT
ISNUMBER
ISTEXT

Math / aggregation

SUM
AVERAGE
COUNT
COUNTA
COUNTBLANK
MAX
MIN
MEDIAN
ABS
ROUND
ROUNDDOWN
ROUNDUP
MROUND
TRUNC
MOD
DIVIDE
POWER
SQRT
EXP
LN
LOG
LOG10
RAND
RANDBETWEEN
RANK

Reference

SELECT
FAST
SELECTSAMPLE
THIS
PTHIS
PPRIOR
PREF
POFFSET
PRIOR
ALL
PRANGE
PVERTICAL
CUMULATIVE
CHOOSE
FIRST
LAST
VALUE
VLENGTH
PRANK
COL
ROW

Date

DATE
DATEOP
DATEDIF
DAYS
DAY
MONTH
YEAR
QUARTER
WEEKDAY
WEEKNUM
ENDOFMONTH
EOMONTH
SOMONTH
NETWORKDAYS
YEARFRAC
FISCALQUARTER
FISCALQUARTEREND
FISCALYEAR
FISCALYEAREND
TODAY

Text

CONCAT
CONTAINS
STARTSWITH
ENDSWITH
EXACT
LEFT
RIGHT
MID
LEN
REPLACE
SUBSTITUTE
TRIM
LOWER
UPPER
STRING
LISTAGG
HYPERLINK

Finance

IRR
NPV
CUMIPMT
CUMPRINC
FV
IPMT
PPMT
NPER
PMT
PV
RATE
SLN
DDB
DB
SYD

Added in FiniDB v2

PREV("dim"[, n]), NEXT("dim"[, n])time-axis shorthand for PPRIOR along periods_dim_id; out of range → blank
ISERROR(v), ERROR("code")error values
IFBLANK(v, alt)blank handling without IF(ISBLANK(...))
PERIOD(date, "periods_table")maps a date to the id of the period containing it
YTD("member"), QTD("member")CUMULATIVE bounded by fiscal year / quarter
SUMPRODUCT(arr, arr), VAR, STDEVcommon analysis needs
LOOKUP("dim","table","key_dim", key)sugar for a scalar SELECT with one equality
TEXT(v, "format")numeral-style formatting in strings

Removed from the legacy catalog: PSELECT, EVAL, TIMEDILATOR; deferred: RADIALCLUSTER, GEOASSIGN, GEOBALANCE, UDFs. Grammar and restrictions are in the guide.