Forum Discussion

Rigoleto's avatar
Rigoleto
Helper II
8 years ago
Solved

Add commas to a text numeric value

I having problems to format some values that are being showing in a Matrix, just I did some trick in order to simulate the Totals and Averages, I have changed to values data types from int to text, m...
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Rigoleto

    Thanks to ChrisMendoza, i can test with it successfully.

    Column =
VAR right =
    RIGHT ( [Column1], 3 )
VAR left =
    SUBSTITUTE ( [Column1], right, "" )
RETURN
    COMBINEVALUES ( ",", left, right )

     

     

    Best regards

    maggie 

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Rigoleto

Thanks to ChrisMendoza, i can test with it successfully.

Column =
VAR right =
    RIGHT ( [Column1], 3 )
VAR left =
    SUBSTITUTE ( [Column1], right, "" )
RETURN
    COMBINEVALUES ( ",", left, right )

 

 

Best regards

maggie