Skip to Content
0

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

Nov 15, 2017 at 01:36 PM

32

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Kuldeep Ghosh Nov 15, 2017 at 03:05 PM
0

Which version are you using?

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Nov 15, 2017 at 01:38 PM
0

try this.

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

Share
10 |10000 characters needed characters left characters exceeded