Forum Discussion

JFlak's avatar
JFlak
New Contributor
3 years ago

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...
Excel Add In
NidhiMangtani's avatar
NidhiMangtani
Contributor III
3 years ago

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.