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
JFlak
3 years agoNew Contributor
Table View Formatting - Displaying Commas in Numeric Columns
Does anyone know if it is possible to display commas within numeric columns in the table view feature? I have attempted to make this work both through the business rule and using formatting within t...
NidhiMangtani
3 years agoContributor III
Hello,
In your select query for GetTableView in spreadsheet business rule, apply format on the numeric column.
SELECT FORMAT(column1, '#,#') from tablename
GetTableView gets called when spreadsheet is refreshed so the formatting would sustain.
Hope this helps.
Related Content
- 3 years ago
- 2 years ago
- 3 years ago