Home
Functions and formulas
HTML
HTML
HTML function is not supported in custom reports in
Infor
cloud.
Side TOC
Side TOC
Functions and formulas
Specifying formulas
Optimization
ADDRESS
ADDSLICEAXISATTRIBUTES
ADDSLICEAXISATTRIBUTESA
ADDSLICEAXISATTRIBUTESORT
ADDSLICEAXISLIMIT
ADDSLICEAXISRANKING
ADDSLICEAXISVALUESORT
ARRAY
ARRAYINDEXOF
ARRAYINSERT
ARRAYLENGTH
ARRAYREMOVE
ARRAYSORT
ARRAYSWAP
ARRAYTONUMBERS
ARRAYTOSTRING
ATTACHMENTINFO
ATTACHMENTS
CELLGET
CELLPROPERTYGET
CELLPROPERTYWRITE
CELLWRITE
CLIENTTIMESHIFT
CREATESLICEAXIS
CREATESLICEDEFINITION
CREATESLICELIST
CREATESLICELISTS
CREATESLICELISTSEGMENT
CREATESLICETUPLESEGMENTS
CROSSLINK
DBEXECUTE
DBEXECUTEFIXED
DELETEATTACHMENT
EXTRACTPROPERTIES
EXTRACTPROPERTIESBYFILTER
FILTER
FINDKEYS
FINDKEYSA
FINDKEYSBYFILTER
FINDKEYSBYFILTERA
FORMATSTRING
GETARRAYITEM
GETCOLOR
GETCOLORRANGE
GETENVIRONMENTINFO
GETKEY
GETKEYS
GETKEYSA
GETKEYVALUES
GETKEYVALUESA
GETLEVEL
GETNAME
GETOLAPNAME
GETOLAPNAMEA
GETPROPERTIES
GETPROPERTIESA
GETPROPERTY
GETPROPERTYVALUES
GETPROPERTYVALUESA
GETSESSIONID
GETTICKET
GROWTHX and GROWTHY
HLOOKUP
HTML
HYPERBLOCK
HYPERLINK
IFERROR
INITSLICERS
INSERTSLICEAXISATTRIBUTESORT
INSERTSLICEAXISRANKING
INSERTSLICEAXISVALUESORT
ISEXPANDED
ISMULTISELECT
KEYGET
LINESTB, LINESTM, LINESTR
LOGESTB, LOGESTM, LOGESTR
MEMBERCNAME
MEMBERGET
MEMBERNAME
MERGEPROPERTIES
MULTISELECTADD
MULTISELECTCHANGEAGGREGATION
MULTISELECTCREATE
MULTISELECTGETMEMBERS
MULTISELECTGETMEMBERSSIMPLE
MULTISELECTGETMEMBERSSIMPLEA
MULTISELECTREMOVE
NFMTFROMNEUTRAL
NFMTTONEUTRAL
NOTEGET
NOTEWRITE
RDB
REFRESHOLAPMETADATA
ROA
ROAC
ROC
ROK
RON
RUNPROCESS
RWA
RWAC
RWC
RWDB
RWN
SERVERTIMESHIFT
SETPROPERTY
SLICEADDAXISFILTERS
SLICECREATCALCULATEDMEMBERS
SLICECREATECALCULATEDMEMBERSXML
SLICEGET
SLICEWRITE
SPLITELEMENTNAMES
STYLENUMBERFORMAT
SUMIF2
TEXT
TEXTNEUTRAL
TRANSLATESTRING
TRANSLATEUNIQUESTRING
VALIDATESLICERS
VALUE
VALUENEUTRAL
VLOOKUP
WBA
WBC
Optional OLAP cell properties
Named ranges