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
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...
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 = N1End If
Hello, I tried NumberFormat = N1, Scale = 6 and it works in terms of displaying the numbers in millions, however it messed up some percentage calculations that I was making beforehand. I think this is because of the scaling. Is there a way to get around it?
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
Thank you Leasa, this works for me in this instance!