AsNumber(expression)

Category: Special function

This function converts expression to a number.

This is useful when you wish to validate the contents of a field or retrieve the number value of a field.

Return value type: Number

• Text should have only digits and one decimal point.
• Boolean is converted into -1 (TRUE) or 0 (FALSE).
• Number remains itself.
• Everything else returns error.

asnumber( '123.45' )  //Returns 123.45

asnumber( 543.21 )  //Returns 543.21

asnumber( 1 > 2 )  //Returns 0  (FALSE result of an expression.)

asnumber( 'text' )  //Returns '#Can't convert to number'

• AsText(expression)