Forum Discussion

Nazdac911's avatar
Nazdac911
Icon for Helper II rankHelper II
3 years ago

Convert a text value to a numeric vale

Hi all 

I have a column type text that contains numbers and text : I want to apply the follwoing script : 

when I apply this I get the follwoing message : 

I treid to use convert , but it did not work .. 
the idea that if I instead of using VAR , i build a separate measure for each one , then it will work !!! 

Any suggestions 🙂 
thanks in advance 
regards 

 

2 Replies

    • Nazdac911's avatar
      Nazdac911
      Icon for Helper II rankHelper II

      By doing that, numbere will only concat beaside each other , but not calcualted .. 
      The resulted A1 , A2 and A3 are numeric values exsist in a text table