Difference between revisions of "Formula Functions"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
| (20 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Formula functions are logical and programmatic functions | ==About the Formula Functions== | ||
Formula functions are logical and programmatic functions that can be included anywhere that a [[Formula Expression]] is defined. | |||
The | == Conventions == | ||
: | |||
The following conventions are used in these functions: | |||
:{| border="1" cellpadding="5" cellspacing="0" | |||
!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 == | == Date Functions == | ||
| Line 17: | Line 28: | ||
See [[Date]] for details about these Day, Date and Time-related formula functions: | See [[Date]] for details about these Day, Date and Time-related formula functions: | ||
{| border="0" cellpadding="5" cellspacing="0" width="50%" | :{| border="0" cellpadding="5" cellspacing="0" width="50%" | ||
|-valign="top" | |-valign="top" | ||
| | | | ||
| Line 65: | Line 76: | ||
See [[Logical]] for details about functions resulting in TRUE/FALSE (YES/NO, 1/0): | See [[Logical]] for details about functions resulting in TRUE/FALSE (YES/NO, 1/0): | ||
{| border="0" cellpadding="5" cellspacing="0" width="50%" | :{| border="0" cellpadding="5" cellspacing="0" width="50%" | ||
|-valign="top" | |-valign="top" | ||
| | | | ||
[[AND]]<br> | [[AND]]<br> | ||
[[OR]] | |||
| | |||
[[IF]]<br> | [[IF]]<br> | ||
[[NOT]] | |||
| | |||
[[ISCHANGED]]<br> | [[ISCHANGED]]<br> | ||
[[ISNEW]]<br> | |||
[[ISNEW]] | |||
[[ISNULL]]<br> | [[ISNULL]]<br> | ||
[[ISBLANK]] | |||
[[ | |||
|} | |} | ||
| Line 88: | Line 96: | ||
See [[Math]] for details about mathematical functions: | See [[Math]] for details about mathematical functions: | ||
{| border="0" cellpadding="5" cellspacing="0" width="50%" | :{| border="0" cellpadding="5" cellspacing="0" width="50%" | ||
|-valign="top" | |-valign="top" | ||
| | | | ||
| Line 122: | Line 130: | ||
See [[Text]] for details about text-related formula functions: | See [[Text]] for details about text-related formula functions: | ||
{| border="0" cellpadding="5" cellspacing="0" width="50%" | :{| border="0" cellpadding="5" cellspacing="0" width="50%" | ||
|-valign="top" | |-valign="top" | ||
| | | | ||
| Line 151: | Line 159: | ||
[[VALUE]]<br> | [[VALUE]]<br> | ||
|} | |} | ||
== Aggregate Functions == | == 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. | |||
- | {| border="0" cellpadding="5" cellspacing="0" width="50%" | ||
|-valign="top" | |||
| [[Aggregate Functions#MAX|MAXIMUM]] <br> [[Aggregate Functions#MIN|MINIMUM]] | |||
| [[Aggregate Functions#SUM|SUM]] <br> [[Aggregate Functions#AVG|AVG]] | |||
| [[Aggregate Functions#COUNT|COUNT]] | |||
|} | |||
{| border="0" cellpadding="5" cellspacing="0" width="50%" | ==Miscellaneous Functions== | ||
:{| border="0" cellpadding="5" cellspacing="0" width="50%" | |||
|-valign="top" | |-valign="top" | ||
| | | | ||
| Line 164: | Line 178: | ||
| | | | ||
[[PRIORVALUE]] | [[PRIORVALUE]] | ||
|} | |} | ||
Latest revision as of 11:49, 7 May 2018
About the Formula Functions
Formula functions are logical and programmatic functions that can be included anywhere that a Formula Expression is defined.
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:
Logical Functions
See Logical for details about functions resulting in TRUE/FALSE (YES/NO, 1/0):
Math Functions
See Math for details about mathematical functions:
Text Functions
See Text for details about text-related formula functions:
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 |