Using Functions

In This Section:

Mathematical Functions

Text Functions

List of Functions

CalcStatus

CellText

CountA

DataSource

Date

Difference

Eval

Footnote

GetCell

GetHeading

ListOfCellDocuments

IfThen, If

Max

MemberAlias

MemberDescription

MemberName

MemberProperty

MemberQualifiedName

Min

Mod

Page

PageCount

PercentOfTotal

Pi

PlanningAnnotations

ProcessManagementStatus

Product

Random

Rank

ReportAuthor

ReportCreated

ReportDesc

ReportFolder

ReportModified

ReportModifiedBy

ReportName

ReportRunBy

RetrieveValue

Round

Sqrt

Sum

Truncate / Trunc

VariableValue

Variance / Var

VariancePercent / VarPer

xbrlUnit

xbrlContext

xbrlLineItem

Mathematical Operators in Expressions

Mathematical Operands in Expressions

Natural Precedence

You use functions to create formulas. A formula is a series of functions and operators that produce data shown in a report. Financial Reporting functions are organized into two groups: mathematical functions and text functions. This chapter provides information about how to use functions.