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...
Forum Discussion
Hey FM,
Take a look at this thread. I provided an example with attached syntax on how we use UD8 as a Reporting Helpers dimension and allow the users to run reports or use the excel add-in to dynamically scale their numbers (whole numbers, scaled to thousands, and scaled to millions).
Re: XFgetcell pulls in future months as YTD negative - OneStream Community (onestreamsoftware.com)
aricgresko, I appreciate your post but it seems more involved than I was hoping for. I would expect that changing number formatting should be easier than that.
Hi aricgresco
This is very helpful, if you want to make different versions of scaling available for everybody, but maybe too much if you only need it for a report.
