Skip to main content

 

Planview Customer Success Center

ToNumber Function

ToNumber (value as String) as Numeric

Category: Convert
Description: Converts a text value to a number. Returns a run-time exception if cannot convert
Supported Context: FormulaField And BusinessRules
Parameters:  
value as String Represents a text or string number value or reference to a field that returns a string number value
Returned value as Numeric Returns a numeric value equal to the text or string number value entered in the "value" parameter. Returns a run-time exception if cannot convert (i.e. text/string entered in "value" contains characters that are not numeric)
Example #1

Convert a text field with string values to number values

ToNumber("567")

Tips
  • To prevent run time errors, use the Catch() exception
  • To convert picklist values of number types to numbers for formula calculations use the ToNumber(ToString($picklistfield))
Related Functions

Catch()