Skip to content

MODLR

Main Navigation Technical

Modelling Guides

Sidebar Navigation

Cube Functions

Conditional Functions

AND

IF

NOT

OR

SWITCH

XOR

Datasource Functions

SQLCOLUMN

SQLCOLUMNNAME

SQLROW

SQLVALUE

Date Functions

DATE

DATEDIF

DATEVALUE

DAY

DAYS

EDATE

EOMONTH

FORMATDATE

FORMATTIME

HOUR

MINUTE

MONTH

MONTHDAYCOUNT

MONTHDAYS

MONTHWORKDAYS

NETWORKDAYS

NOW

SECOND

SNETWORKDAYS

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKDAYEX

WEEKNUM

WORKDAY

YEAR

Dimension Functions

ALIAS

CHILD

CHILDCOUNT

CHILDPOSITION

CHILDREN

CONTAINSSTATICVALUES

CONTEXTDUMP

COUNTSTATICVALUES

DESCENDANTS

ELEMENT

ELEMENTBYPOSITION

ELEMENTEXISTS

ELEMENTHASANCESTOR

ELEMENTTYPE

HASSTATICVALUE

HIERARCHYHASMEMBER

ISLEAF

ISLEVELZERO

LEVELSBETWEEN

MAPPEDELEMENT

NTHCOUNT

OFFSET

PARENT

PARENTCOUNT

POSITION

SUMSTATICVALUES

Financial Functions

CUBEIRR

CUBEXIRR

FV

IPMT

NPER

PMT

PPMT

PV

RATE

Modelling Functions

CONSOLIDATEAVERAGE

CONSOLIDATEAVERAGENOZEROS

CONSOLIDATEMAX

CONSOLIDATEMAXNOZEROS

CONSOLIDATEMEDIAN

CONSOLIDATEMEDIANNOZEROS

CONSOLIDATEMIN

CONSOLIDATEMINNOZEROS

CONSOLIDATESTANDARDDEVIATION

CONSOLIDATESTANDARDDEVIATIONNOZEROS

FIELD

FIRSTDESCENDANTVALUE

FIRSTPOPULATEDDESCENDANTVALUE

LASTDESCENDANTVALUE

LASTPOPULATEDDESCENDANTVALUE

LINK

LINKBY

LINKDIM

MAPPING

SEQUENCE

VARIABLE

Numeric Functions

ABS

ACOS

ARRAY

ASIN

ATAN

AVERAGE

AVERAGENOZEROS

CEIL

COLORDARKEN

COLORHUESHIFT

COLORINVERT

COLORLERP

COLORLIGHTEN

CONTAINS

COS

COSH

EXP

FLOOR

INT

LOG

MAX

MEDIAN

MIN

MODE

NUMBER

NUMBERFORMAT

OCCURRENCES

POW

POWER

RAND

RANDBETWEEN

ROUND

SECH

SIN

SQRT

STDDEV

STRING

TAN

String Functions

LEFT

LEN

LOWER

MID

PROPER

REPEAT

REPLACE

REPT

RIGHT

SEARCH

SPLIT

SUBSTITUTE

TOGGLESTRING

TRIM

TRIMLEFT

TRIMRIGHT

UPPER

URLDECODE

URLENCODE

User Functions

USERCARDACCESS

USERHASGROUP

On this page

REPEAT

See REPT.

Last updated:

Pager

Previous pagePROPER

Next pageREPLACE

REPEAT ​

REPEAT