Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 689
See also “Example 1: counting null values in a column” on page 630
“Example 4: displaying all data when a column allows nulls” on page 638
IsNumber
Description Reports whether the value of a string is a number.
Syntax IsNumber ( string )
Return value
Boolean. Returns true if string is a valid number and false if it is not.
Examples This expression returns true:
IsNumber("32.65")
This expression returns false:
IsNumber("A16")
This expression for a computed field returns “Not a valid age” if age does not
contain a number:
If(IsNumber(age), age, "Not a valid age")
To pass this validation rule, Age_nbr must be a number:
IsNumber(Age_nbr) = true
See also
Integer
IsRowModified
Description Reports whether the row has been modified.
Syntax IsRowModified ( )
Return value
Boolean. Returns true if the row has been modified and false if it has not.
Usage In a report, when you use IsRowModified in bands other than the detail band, it
reports on a row in the detail band. See
GetRow for a table specifying which
row is associated with each band for reporting purposes.
Argument Description
string A string whose value you want to test to determine whether it is a
valid number