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
Scaling in Quick views
Wondering if anyone knows how to scale data in quick views. Looked through the formatting options and couldn't find anything that would do what I'm looking for. ie. 123,445 can be scaled in thousands...
Hi Scott,
You can define in Excel a custom Cell Style, that will include all the formatting you need including the scaling.
https://support.microsoft.com/en-us/office/apply-create-or-remove-a-cell-style-472213bf-66bd-40c8-815c-594f0f90cd22
Once the new Cell Style is defined, it will be visible in the QuickView Settings under 'Excel Styles'.
Hope it helps
Liliya
Hi Scott,
You can define in Excel a custom Cell Style, that will include all the formatting you need including the scaling.
https://support.microsoft.com/en-us/office/apply-create-or-remove-a-cell-style-472213bf-66bd-40c8-815c-594f0f90cd22
Once the new Cell Style is defined, it will be visible in the QuickView Settings under 'Excel Styles'.
Hope it helps
Liliya
Thanks for your reply solution, it works!
How did you set the scaling in the formatting?
I know this post is several years old, but do I have to do anything in-between creating the custom style and using it inside the OS application? It works for me if I use it in Excel, but when I try to use it in the OS CV, it doesn't populate as a style option.
