Which formulas and functions are available?

You can add functions to the spreadsheet in order to perform calculations, for example. Different formulas are available to you, depending on whether you are editing a model of the Spreadsheet type, a results table of a query, or an ad hoc analysis.

Topics

AND

ARIS_ATTRIBUTE

ARIS_ATTRIBUTE_VALUE

ARIS_ITEM

ARIS_ITEM_API_NAME

ARIS_ITEM_DEF_SYMBOL

ARIS_ITEM_GUID

ARIS_ITEM_PATH

ARIS_ITEM_TYPE

ARIS_ITEM_TYPE_NUM

ARIS_LOCKED_BY_USER

ARIS_WRITE_ATTRIBUTE_VALUE

AVERAGE

CHOOSE

CONCATENATE

COUNT

DATE

DAYS

IF

IS_CONNECTED_BY

MAX

MIN

NETWORKDAYS

NOT

NOW

OR

SQRT

STANDARDIZE

SUM

SWITCH

TIME

TODAY

XOR