@IsNumber (Formula Language)

Indicates if a given value is a number (or a number list).

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)