0

How to convert decimal String to decimal number

Hayhay,

I wanted to work with a number. Then I noticed, that the number is a string (value: 10,50). So I tried making a number out of it. But turns out:

number() can only handle digits, not a decimal numbers

formatDate() has no option to convert a string

I tried splitting it with

item(split(string, ","), 0)
item(split(string, ","), 1)

But could't put it back being a number.

Help is appreciated.

1 Antwort

null
    • Torsten_Stang.1
    • vor 1 Jahr
    • Gemeldet - anzeigen
    let myText := split('Number as Text', ",");
    number(item(myText, 0)) + number(item(myText, 1)) / 100
    

Content aside

  • Status Answered
  • vor 1 JahrZuletzt aktiv
  • 1Antworten
  • 32Ansichten
  • 2 Folge bereits