Contents x
    ConvertToNumber
    • 13 Dec 2023
    • 1 Minute to read
    • Dark
      Light
    Contents

    ConvertToNumber

    • Updated on 13 Dec 2023
    • 1 Minute to read
    • Dark
      Light
    Article summary

    General

    The ConvertToNumber function can be used to convert a value to a Number.

    NOTE

    If the value cannot be converted to a number (e.g. when trying to convert the String "This is a text" to a number), the execution of the report document preview or task will fail.

    Syntax

    The syntax of the ConvertToNumber function is:

    ConvertToNumber Function Syntax

    ConvertToNumber(<value>)

    Examples

    The following Expression returns the value of the variable vTest of Datasource MyDatasource as Number:

    ConvertToNumber Function Example

    ConvertToNumber([Datasource].[MyDatasources].[Variable].[vTest])

    If the variable contains a String with value "123" then the returned number will be 123.

    Was this article helpful?
    What's Next