Description
Logical Syntax
boolean Even(number input_number)
Input
Any number input_number
Output
True if the number is even; false otherwise Examples
Even(4)returns true. Even(23.2)returns false. Even(24.2)returns true.
Notes
Even()returns a boolean value that you can use in the If function. If you place the function directly into a column, Web Intelligence converts the return value to an integer. You can format this number using a Boolean number format.
IsDate
Description
Determines whether a variable has the date data type Function Group
boolean IsDate(object)
Input
Any object
object
Output
True if the object is of data type date; false if not. Examples
IsDate(Reservation Date)returns True if Reservation Date has the date data type
If(IsDate(Reservation Date;"Date";"Not a date")returns "Date" if Reservation Date has the date data type
Note
IsDate()returns a boolean value that you can use in the If function. If you placeIsDate()directly into a column, Web Intelligence converts the return value to an integer. You can format this number using a Boolean number format.
Related Topics
• Ifon page 173 IsError
Description
Determines whether a variable returns an error Function Group
boolean IsError(object)
Input
Any object
object
Output
True if the object returns an error; false otherwise Examples
IsError(Revenue)returns false if the Revenue variable does not return an error
IsError(Average Guests)returns true if the Average Guests variable returns a division by zero (#DIV/0) error
If (IsError(Sales Revenue);"Error";"No Error")returns "Error" if the Sales Revenue variable returns an error
Note
IsError()returns a boolean value that you can use in theIf()function. If you placeIsError()directly into a column, Web Intelligence converts the return value to an integer. You can format this number using a Boolean number format.
Related Topics
• Ifon page 173 IsLogical
Description
Logical Syntax boolean IsLogical(object) Input Any object object Output
True if the object has a boolean data type; false otherwise Examples
IsLogical(IsString)returns true if the IsString variable has the formula
IsString(Country)
If (IsLogical(IsString;"Logical";"Not logical")returns "Logical" if the IsString variable has the formulaIsString( Country )
Note
IsLogical()returns a boolean value that you can use in theIf()function. If you placeIsLogical()directly into a column, Web Intelligence converts the return value to an integer. You can format this number using a Boolean number format.
Related Topics
• Ifon page 173 IsNull
Description
Logical Syntax boolean IsNull(object) Input Any object object Output
True if the object is null; false otherwise Examples
IsNull(Revenue ) returns false if the Revenue variable is not null.
IsNull(Average Guests) returns true if the Average Guests variable is null. If(IsNull(Sales Revenue);"Null";"Not Null") returns "Null" if the Sales Revenue variable is null.
Note
IsNull()returns a boolean value that you can use in theIf()function. If you placeIsNull()directly into a column, Web Intelligence converts the return value to an integer. You can format this number using a Boolean number format.
Related Topics
• Ifon page 173 IsNumber
Description
Logical Syntax boolean IsNumber(object) Input Any object object Output
True if the object is a number; false otherwise Examples
IsNumber(Revenue)returns true if the Revenue variable is a number. IsNumber(Customer Name)returns false if the Customer Name variable is not a number.
If (IsNumber (Sales Revenue);"Number";"Not a number")returns "Number" if the Sales Revenue variable is numerical
Note
IsNumber()returns a boolean value that you can use in theIf()function. If you placeIsNumber()directly into a column, Web Intelligence converts the return value to an integer. You can format this number using a Boolean number format.
Related Topics
• Ifon page 173 IsPromptAnswered
Boolean Syntax
boolean IsPromptAnswered (object data_provider; string prompt)
Input
The data provider (optional) data_provider
The text associated with a prompt prompt
Output
True if the prompt has been answered; false if not Example
IsPromptAnswered ( [Sales];"Choose a city")returns true if the prompt identified by the text "Choose a city" in the [Sales] data provider has been answered.
Note
You must enclose the name of the data provider in square brackets
IsString
Description
Determines whether a variable is a string Function Group
Logical Syntax
Any object
object
Output
True if the object is a string; false otherwise Examples
IsString(Revenue)returns false if the Revenue variable is not a string. IsString(Customer Name)returns true if the Customer Name variable is a string.
If(IsStringCountry);"String";"Not a string")returns "String" if the Country variable is a string.
Note
IsString()returns a boolean value that you can use in theIf()function. If you placeIsString()directly into a column, Web Intelligence converts the return value to an integer. You can format this number using a Boolean number format.
Related Topics
• Ifon page 173 IsTime
Description
Determines whether a variable is a time variable Function Group
Logical Syntax
Any object
object
Output
True if the variable is a time variable; false otherwise Examples
IsTime(Reservation Time)returns true if the Reservation Time variable is a time variable.
IsTime(Average Guests)returns false if the Average Guests variable is not a time variable.
If(IsTime(Reservation Time);"Time";"Not time")returns "Time" if the Reservation Time variable is a time variable.
Note
IsTime()returns a boolean value that you can use in theIf()function. If you placeIsTime()directly into a column, Web Intelligence converts the return value to an integer. You can format this number using a Boolean number format.
Related Topics
• Ifon page 173 Odd
Description
Determines whether a number is odd Function Group
boolean Odd(number input_number)
Input
Any number
input_number
Output
True if the number is odd; false otherwise Example
Odd(5)returns true. Odd(23.2)returns true. Odd(24.2)returns false.
If(Odd(Sales Revenue);'Odd';'Even')returns 'Odd' if Sales Revenue has an odd value.
Notes
• Odd()returns a boolean value that you can use in theIf()function. If you placeOdd()directly into a column, Web Intelligence converts the return value to an integer. You can format this number using a Boolean number format.
• Odd()ignores the fractional parts of decimal numbers
Related Topics