Skip to main content
OneStream Employee
GregJohnsonOneStream Employee
OneStream Employee
May 25, 2023 1:57 PM UTC

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.

    4 replies

    NicolasArgente
    Veteran
    May 25, 2023 2:16 PM UTC

    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
      Employee - Advisor
      ChristianWEmployee - Advisor
      Employee - Advisor
      May 25, 2023 5:49 PM UTC

      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
        Veteran
        May 26, 2023 6:41 AM UTC

        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

         

        Employee - Sage
        JackLacavaEmployee - Sage
        Employee - Sage
        May 26, 2023 10:01 AM UTC

        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