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

FM's avatar
FM
New Contributor III
3 years ago
Solved

Cube View NumberFormat for millions

Hello, Is there a way to make cells display numerical data in the millions of dollars amount? As an example 1,500,000 would be displayed as 1.5 I have looked around but did not find much informat...
Cube View
  • Leasa's avatar
    Leasa
    3 years ago

    Hi, then you can try the conditional formatting.

    For example, you can choose to only apply the scale to the rows without "percentage" in the row names using the below: 

    If (RowName DoesNotContain 'percentage') Then
    Scale = 6, NumberFormat = N1

    End If

aricgresko's avatar
aricgresko
Contributor III
3 years ago

For a single report, yes my suggestion would be more involved than needed and Christian's suggestion is the way to go.  I'm assuming you would want to drive consistency among all reports, so a good way to do that is to leverage the UD8 scaling idea.  Either way, I think you have a few good options!