@IsNumber (Formula Language)

Syntax

@IsNumber( value )

Parameters

value

Any data type. Any value.

Return value

flag

Boolean

• Returns 1 (True) if the value is a number or a number list
• Returns 0 (False) if the value is not a number or a number list

Usage

This is a useful function for checking to see that you have assigned field data types correctly.

The parameter must be a number, not a non-numeric value (for example, text) that can be converted to a number.

Examples

1. This example returns 1.

   @IsNumber(123)

2. This example returns 0.

   @IsNumber("123")

3. This example returns 0.

   @IsNumber(@Created)

4. This example returns 1.

   @IsNumber(-345:2.78:997:.7)

5. This example returns 1 if the field named CostCenters contains a list of number values; returns 0 if the list contains at least one text string.

   @IsNumber(CostCenters)