Skip to main content
G
GregJohnson
May 25, 2023

Drill down formula formatting

  • May 25, 2023
  • 3 replies
  • 0 views

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.

3 replies

N
NicolasArgente
May 25, 2023

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 😃

C
ChristianW
May 25, 2023

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.

N
NicolasArgente
May 26, 2023

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

 

J
JackLacava
May 26, 2023

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.

Terms & ConditionsAccessibility statement