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
sfilho's avatar
sfilho
New Contributor III
2 years ago

The users want the excel populated and format ready. If there is no other way then I will discuss alternatives with them. Thank you for confirming the behavior.

ckattookaran's avatar
ckattookaran
VIP
2 years ago

You could file an enhancement request for the ColumnFormat like AsCurrency (there is already one for AsPercentage).

  • RandyThompson's avatar
    RandyThompson
    New Contributor III
    2 years ago

    I have submitted this enhancement on IdeaStream.

    Currently when opening the same Table View we can get the formatting we want in a native Excel Table View (right-justified currency fields) but not in the OneStream Spreadsheet tool (left-justified Text field).