Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
5 years ago

Does anyone have any idea how to show commas in my dashboard grid view?

Originally posted by Craig Rowe

9/23/2020

I am working with Relational Blending and pulling data from Stage into a dashboard. I am trying to format the value of my data into currency. When I use the query in SQL Server, I can see the correct format, with commas. When I put the same query into my business rule, see the format change the number of decimal places but I don't see the commas.

Dashboards

1 Reply

  • OSAdmin's avatar
    OSAdmin
    Icon for OneStream Employee rankOneStream Employee
    5 years ago
    Originally posted by Nick Kroppe

    To format a field in the grid view component, set the "Default For Columns Are Visible" property to False. You will then have to manually call out the fields you want to display in the grid view and specify the column name and is visible = True property. From there, You can individually format each field using Microsoft String Formatting capabilities.