Formulas and functions

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