Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert minus number

How can I convert -1.5 of type text to number?  I tried with value() but getting error :   Cannot convert '-1.5' of type text to type number.    
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    You can use the CONVERT() function keeping the second argument as Double. 

    For Example: 

    ConvertToDecimal = CONVERT(ALL('Table1'[Column1]),DOUBLE)
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

You can use the CONVERT() function keeping the second argument as Double. 

For Example: 

ConvertToDecimal = CONVERT(ALL('Table1'[Column1]),DOUBLE)