Forum Discussion
GregJohnson
OneStream Employee
OneStream EmployeeDrill down formula formatting
Is there any way to format a number for the FORMULA DRILL DOWN to show as more than two decimal places or format the output as a percentage? I have some factors that are applied against another account that need 4 or more decimal places to look like they calculate correctly. In the example below, the number should be .0588.
4 Replies
GregJohnson I do not think you can do that by default. As you know some drill down can be coded too (like for dynamic calcs) but even there, you can not change the value or format it. At least, not that I am aware.
I would love it if someone can proove me wrong 😃
ChristianWYou can set the default number format in application settings. But it will affect all displayed numbers in OneStream (like cubeviews and journals), not only the drill down screen. Of cause you can override the default number format in cubeviews.
Hi ChristianW ,
Sorry, I am a bit confused here. Are you saying it is possible to format a drill down? I gave it a try on my side, but I have no clue on how to do that. Or did I misunderstood what you meant? Thanks. 
- JackLacava
The Formula for Calculation Drill Down is just a helper for the interface, so that you can tell the application which records to fish out of the database and display. You don't have control on the formatting, unfortunately.
