ConvertToNumber

Returns the number based on a string representation of a number. 

  • Returned Output: Numeric
  • Library: PQL \ Common \ Math
  • Version: 2018.00.000
  • Compatibility:
    • Can be combined with and other PQL function throughout the application.
    • It CANNOT be used with MDX or VBA functions. But it can be used on MDX-based content in other parts of the application.

Syntax

ConvertToNumber( <Text> )

* Click on the function's arguments above for more details on the input values.

Comments
  • The text string value must be a text or string representation of a number.
Different Function types
  • This function is like the Excel VALUE function.

Examples

This example returns the number 123

ConvertToNumber("123")