List of Functions Available in Datawindow Expressions

Expressions are most commonly used to create datawindow column property expressions. But the are also used to create filter and find strings.

Aggregate

• Avg
• Count
• CumulativePercent
• CumulativeSum
• First
• Large
• Last
• Max
• Median
• Min
• Mode
• Percent
• Small
• StDev
• StDevP
• Sum
• Var
• VarP

Crosstab

• CrosstabAvg
• CrosstabCount
• CrosstabMax
• CrosstabMin
• CrosstabSum

Data Type Checking

• Asc
• Char
• Integer
• IsDate
• IsNull
• IsNumber
• IsTime
• Long
• Number

Datawindow information

• CurrentRow
• Describe
• GetRow
• GetText
• IsRowModified
• IsRowNew
• IsSelected
• LookUpDisplay
• Page
• PageAcross
• PageCount
• PageCountAcross
• RowCount
• RowHeight

Day, Date, and Time

• Date
• DateTime
• Day
• DayName
• DayNumber
• DaysAfter
• Hour
• Minute
• Month
• Now
• RelativeDate
• RelativeTime
• Second
• SecondsAfter
• Time
• Today
• Year

Miscellaneous

• Bitmap
• Case
• If
• ProfileInt
• ProfileString
• RGB

Numeric

• Abs
• Ceiling
• Cos
• Exp
• Fact
• Int
• Log
• LogTen
• Max
• Min
• Mod
• Pi
• Rand
• Round
• Sign
• Sin
• Sqrt
• Tan
• Truncate

String

• Fill
• Left
• LeftTrim
• Len
• Lower
• Match
• Mid
• Pos
• Replace
• Right
• RightTrim
• Space
• String
• Trim
• Upper
• WordCap