Convert a text value to a numeric vale

[Nazdac911]

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 

[FreemanZ]

hi @Nazdac911 

try replacing the last line with:

A1&"+"&A2&"+"&A3

[Nazdac911]

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