Financial Reporter Function Notation

Learn more

Financial Reporter functions use the following typographic conventions:

Convention	Description
UPPERCASE	Function names are in uppercase letters.
( )	Function arguments are listed in parentheses.
,	All arguments are separated by a comma. Most argument parameters are text, so are either: In quotation marks A reference to a spreadsheet cell that contains a text value, or a formula that returns a text value Note: Excel will return a "#VALUE!" error if you specify an argument that does not exist.

Convention

Description

UPPERCASE

Function names are in uppercase letters.

( )

Function arguments are listed in parentheses.

All arguments are separated by a comma.

Most argument parameters are text, so are either:

In quotation marks
A reference to a spreadsheet cell that contains a text value, or a formula that returns a text value

Note: Excel will return a "#VALUE!" error if you specify an argument that does not exist.

FRACT(field name, account number)

FRACCT(field name, account number, criteria, format)