Drill down formula formatting

GregJohnson
New Contributor

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 4

NicolasArgente
Valued Contributor

@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 😃

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

ChristianW
Valued Contributor

You 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.

 
 

DrillDownFormat.png

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

JackLacava
Community Manager
Community Manager

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.