Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

ToNumber Function

  1. Last updated
  2. Save as PDF

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()