GetAsNumber
Purpose 
Returns only the numbers in text, as field type number, for use with formulas involving numbers or numeric functions.
Format 
GetAsNumber(text)
Parameters 
text - any text expression or text field containing numbers
Data type returned 
number
Description 
This function drops all non-numeric characters from text.
Examples 
GetAsNumber(“FY98”) returns 98.
GetAsNumber(“$1,254.50”) returns 1254.5.
GetAsNumber(“2 + 2”) returns 22.
GetAsNumber(SerialNumber) returns 35684, when the value of SerialNumber is TKV35FRG6HH84.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.