Skip to Content
avatar image
Former Member

How to change a decimal "string" to "number" in webi 4 ?

the tonumber function gives an error when the string is a decimal other wise when the string is number it works fine

example toNumber("0.2") outputs an error

while toNumber("5556") works fine

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 15, 2017 at 03:05 PM

    Which version are you using?

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 01:38 PM

    try this.

    =ToNumber("0.2";"##")

    Add comment
    10|10000 characters needed characters exceeded