Calculated Fields - Acronyms

Calculated Fields - Acronyms

There are around 34 functions that you can use to create any calculated fields for any desired available BO. 

When trying to create a Calculated Field using one the available functions, while searching for desired function (in task Create Calculated Field ) you can simply type the acronym to find it.

Also notice the input field type (i.e. source field) and the Ouput Field type from each Calc Function below.

Calculated Field Function	Acronym	Input Field Type(s)	Output Field Type
Aggregate Related Instances	ARI	Multi Instance	Multi Instance
Arithmetic Calculation	AC	Numeric or Currency	Numeric
Build Date	BD	Date or Numeric	Date
Concatenate Text	CT	Single Instance or Text	Text
Convert Currency	CC	Currency	Currency
Convert Text to Number	CTN	Text	Number
Count Related Instances	CRI	Multi Instance	Number
Date Constant	DC	*Free Date Format	Date
Date Difference	DD	Date	Numeric
Evaluate Expression	EE	Any	Any
Evaluate Expression Band	EEB	Text	Single Instance
Extract Multi Instance	EMI	Multi Instance or Single Instance	Multi Instance
Extract Single Instance	ESI	Multi Instance	Single Instance
Format Date	FD	Date	Text
Format Number	FN	Number or Currency	Text
Format Text	FT	Text or Single Instance	Text
Increment or Decrement Date	IDD	Date	Date
Lookup Date Rollup	LDR	Date	Single Instance
Lookup Hierarchy	LH	Single Instance	Single Instance
Lookup Hierarchy Rollup	LHR	Single Instance	Single Instance
Lookup Organization	LO	N/A	Single Instance / Multi Instance
Lookup Organization Roles	LOR	N/A	Single Instance / Multi Instance
Lookup Range Band	LRB	Numeric or Currency	Single Instance
Lookup Related Value	LRV	Single Instance	Any
Lookup Translated Value	LTV	Text	Text
Lookup Value as of Date	LVD	Any	Matches Input Value Type
Numeric Constant	NC	*Free Number Format	Numeric
Prompt for Value	PV	Any	Matches Input Value Type
Substring Text	ST	Text or Single Instance	Text
Sum Related Instances	SRI	Single Instance or Multi Instance	Numeric
Text Constant	TC	*Free Text Format	Text
Text Length	TL	Text or Single Instance	Numeric
True/False Condition	TF	Any	Boolean