Appendix B. Calculation Function Reference

Abs()z

Atan()

Average()

Case()

Ceiling()

Choose()

Combination()

Cos()

Count()

DatabaseNames()

Date()

Day()

DayName()

DayOfWeek()

DayOfYear()

Degrees()

Div()

Evaluate()

EvaluationError()

Exact()

Exp()

Extend()

External()

Factorial()

FieldBounds()

FieldComment()

FieldIDs()

FieldNames()

FieldRepetitions()

FieldStyle()

FieldType()

Filter()

FilterValues()

Floor()

FV()

Get(AccountName)

Get(ActiveFieldContents)

Get(ActiveFieldName)

Get(ActiveFieldTableName)

Get(ActiveModifierKeys)

Get(ActiveRepetitionNumber)

Get(ActiveSelectionSize)

Get(ActiveSelectionStart)

Get(AllowAbortState)

Get(ApplicationLanguage)

Get(ApplicationVersion)

Get(CalculationRepetitionNumber)

Get(CurrentDate)

Get(CurrentHostTimestamp)

Get(CurrentTime)

Get(CurrentTimestamp)

Get(ErrorCaptureState)

Get(ExtendedPrivileges)

Get(FileName)

Get(FilePath)

Get(FileSize)

Get(FoundCount)

Get(HighContrastColor)

Get(HighContrastState)

Get(HostName)

Get(LastError)

Get(LastMessageChoice)

Get(LastODBCError)

Get(LayoutAccess)

Get(LayoutCount)

Get(LayoutName)

Get(LayoutNumber)

Get(LayoutTableName)

Get(LayoutViewState)

Get(MultiUserState)

Get(NetworkProtocol)

Get(PageNumber)

Get(PortalRowNumber)

Get(PrinterName)

Get(PrivilegeSetName)

Get(RecordAccess)

Get(RecordID)

Get(RecordModificationCount)

Get(RecordNumber)

Get(RequestCount)

Get(ScreenDepth)

Get(ScreenHeight)

Get(ScreenWidth)

Get(ScriptName)

Get(ScriptParameter)

Get(SortState)

Get(StatusAreaState)

Get(SystemIPAddress)

Get(SystemLanguage)

Get(SystemNICAddress)

Get(SystemPlatform)

Get(SystemVersion)

Get(TotalRecordCount)

Get(UserCount)

Get(UserName)

Get(WindowContentHeight)

Get(WindowContentWidth)

Get(WindowDesktopHeight)

Get(WindowDesktopWidth)

Get(WindowHeight)

Get(WindowLeft)

Get(WindowMode)

Get(WindowName)

Get(WindowTop)

Get(WindowVisible)

Get(WindowWidth)

GetAsCSS()

GetAsDate()

GetAsNumber()

GetAsSVG()

GetAsText()

GetAsTime()

GetAsTimestamp()

GetField()

GetNextSerialValue()

GetRepetition()

GetSummary()

Hour()

If()

Int()

IsEmpty()

IsValid()

IsValidExpression()

Last()

LayoutIDs()

LayoutNames()

Left()

LeftValues()

LeftWords()

Length()

Let()

Lg()

Ln()

Log()

Lookup()

LookupNext()

Lower()

Max()

Middle()

MiddleValues()

MiddleWords()

Min()

Minute()

Mod()

Month()

MonthName()

NPV()

PatternCount()

Pi

PMT()

Position()

Proper()

PV()

Quote()

Radians()

Random

RelationInfo()

Replace()

RGB()

Right()

RightValues()

RightWords()

Round()

ScriptIDs()

ScriptNames()

Seconds()

SerialIncrement()

SetPrecision()

Sign()

Sin()

Sqrt()

StDev()

StDevP()

Substitute()

Sum()

TableIDs()

TableNames()

Tan()

TextColor()

TextFont()

TextSize()

TextStyleAdd()

TextStyleRemove()

Time()

Timestamp()

Trim()

Truncate()

Upper()

ValueCount()

ValueListIDs()

ValueListItems()

ValueListNames()

Variance()

VarianceP()

WeekOfYear()

WeekOfYearFiscal()

WindowNames

WordCount()

Year()