Forum Discussion

GregJohnson's avatar
GregJohnson
New Contributor
2 years ago

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

  • NicolasArgente's avatar
    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 ğŸ˜ƒ

  • ChristianW's avatar
    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.

    • NicolasArgente's avatar
      NicolasArgente
      Valued Contributor

      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's avatar
    JackLacava
    Honored Contributor

    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.