Formula Functions

From AgileApps Support Wiki
Revision as of 01:59, 13 May 2014 by imported>Aeric (→‎Aggregate Functions)

About the Formula Functions

Formula functions are logical and programmatic functions, used with fields and operators to build Formula Expressions in any of the following platform elements:

Conventions

The following conventions are used in these functions:

Element Description
'string' Strings must be enclosed with single quotes
'dString' Date strings must be enclosed with single quotes
int An integer,for example, a number representing the number of days (or months or years)
value An argument in date- and date/time-related Formula Functions, which defines a unit of time
[ ,optional] Optional values are shown in brackets, as [ ,option1, option2]

Date Functions

See Date for details about these Day, Date and Time-related formula functions:

DATE

DATEADD

DATECOMP

DATEPART

DATESUB

DATEVALUE

DAY

HOUR

MINUTE

MONTH

NOW

NULLDATE

NULLTIME

SECOND

TIME

TIMEPART

TIMEVALUE

TODAY

WEEKDAY

YEAR

Logical Functions

See Logical for details about functions resulting in TRUE/FALSE (YES/NO, 1/0):

AND
OR

IF
NOT

ISCHANGED
ISNEW
ISNULL

Math Functions

See Math for details about mathematical functions:

ABS

CEIL

EXP

FLOOR

LN

LOG

MAX

MIN

MOD

POW

ROUND

SQRT

Text Functions

See Text for details about text-related formula functions:

CONCAT

CONTAINS

ENDSWITH

FIND

LEN

LOWER

REPLACE

STARTSWITH

SUBSTRING

TEXT

TRIM

UPPER

VALUE

Aggregate Functions

The Aggregate Functions are not available in every context, because of their potential impact on performance. They let you select a collection of records in an arbitrary object and perform a summary calculation on those records.

MAXIMUM
MINIMUM
SUM
AVG
COUNT

Miscellaneous Functions

LOOKUP

PRIORVALUE