Forum Discussion

RandyThompson's avatar
RandyThompson
New Contributor III
3 years ago

How can we show commas as the thousand separator in a numeric Table View column

We are trying to format numeric columns in a Table View but haven't been successful. The numeric columns are currently appearing as 999999.99 instead of the desired 99,999.99. Are Table View currentl...
Reports
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
3 years ago

Could you try formatting the number in your sql query?

SELECT FORMAT(SomeNumericColumn,'#,0.00') from SOME_TABLE