Reference

This part describes using operators and expressions and InfoMaker expression functions.

Table of Contents

Operators and Expressions
Where you use expressions
Operators used in InfoMaker expressions
Arithmetic operators in InfoMaker expressions
Relational operators in InfoMaker expressions
Logical operators in InfoMaker expressions
Concatenation operator in InfoMaker expressions
Operator precedence in InfoMaker expressions
Matching text patterns
DataWindow Expression and InfoMaker Functions
Using DataWindow expression and InfoMaker functions
Decimal support in DataWindow expressions
Four examples
Example 1: counting null values in a column
Example 2: counting male and female employees
Example 3: creating a row indicator
Example 4: displaying all data when a column allows nulls
Other examples
Alphabetical list of DataWindow expression and InfoMaker 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
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
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