Forum Discussion
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...
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
Format([Column1], "#,##0")
Thanks iris-yip this is the right answer the other examples don't work for 100,000 and above.