The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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