Forum Discussion

kekepania0529's avatar
kekepania0529
Helper I
4 years ago
Solved

Fixed Decimal Number converted to Text issue

I converted a fixed decimal number column to text. Once converted, if the digits after the decimal were zeros, or the last digit was zero, they are being dropped from the text. How can keep the zeros...
Need Help
  • themistoklis's avatar
    themistoklis
    4 years ago

    Try adding SUBSTITUTE function as well

     

    so New Column = SUBSTITUTE( FIXED (TableName[1_GL_Account],2), ",", "")

kekepania0529's avatar
kekepania0529
Helper I
4 years ago

That worked for the decimals, but added commas to the string. Can the commas be removed also? It needs to be formatted like this: 3219001011.05

 

themistoklis's avatar
themistoklis
Community Champion
4 years ago

Try adding SUBSTITUTE function as well

 

so New Column = SUBSTITUTE( FIXED (TableName[1_GL_Account],2), ",", "")