Table of Contents
- Using DataWindow expression functions
- Decimal support in DataWindow expressions
- Four examples
- Alphabetical list of DataWindow expression functions
-
- Abs
- ACos
- Asc
- AscA
- ASin
- ATan
- Avg
- Bitmap
- Case
- Ceiling
- Char
- CharA
- Cos
- Count
- CrosstabAvg
- CrosstabAvgDec
- CrosstabCount
- CrosstabMax
- CrosstabMaxDec
- CrosstabMin
- CrosstabMinDec
- CrosstabSum
- CrosstabSumDec
- CumulativePercent
- CumulativeSum
- CurrentRow
- Date
- DateTime
- Day
- DayName
- DayNumber
- DaysAfter
- Dec
- Describe
- Exp
- Fact
- Fill
- FillA
- First
- FontHeight
- GetPaintDC
- GetPaintRectHeight
- GetPaintRectWidth
- GetPaintRectX
- GetPaintRectY
- GetRow
- GetText
- Hour
- If
- Int
- Integer
- IsDate
- IsExpanded
- IsNull
- IsNumber
- IsRowModified
- IsRowNew
- IsSelected
- IsTime
- Large
- Last
- LastPos
- Left
- LeftA
- LeftTrim
- Len
- LenA
- Log
- LogTen
- Long
- LookUpDisplay
- Lower
- Match
- Max
- Median
- Mid
- MidA
- Min
- Minute
- Mod
- Mode
- Month
- Now
- Number
- Page
- PageAbs
- PageAcross
- PageCount
- PageCountAcross
- Paint
- Percent
- Pi
- Pos
- PosA
- ProfileInt
- ProfileString
- Rand
- Real
- RelativeDate
- RelativeTime
- Replace
- ReplaceA
- RGB
- RichText
- RichTextFile
- Right
- RightA
- RightTrim
- Round
- RowCount
- RowHeight
- Second
- SecondsAfter
- Sign
- Sin
- Small
- Space
- Sqrt
- StDev
- StDevP
- String
- StripRTF
- Sum
- Tan
- Time
- Today
- Trim
- Truncate
- Upper
- Var
- VarP
- WordCap
- Year
About this chapter
This chapter provides syntax, descriptions, and examples of the functions you can use in expressions in the DataWindow painter.
