The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

daniel's avatar
daniel
New Contributor II
1 year ago

negative number format

Hi, I'm trying to set the number format in the Cube Views for negative numbers with gaps instead of a minus. The User culture is in Spanish because I need the decimals with the comma. I don't find...
Cube View
T_Kress's avatar
T_Kress
Icon for OneStream Employee rankOneStream Employee
1 year ago

In your cube view you can take one of the standard number formats and edit it as I did here:

NumberFormat = [#,###,0;     #,###,0;0]

I went here to do so and it worked:

 

  • daniel's avatar
    daniel
    New Contributor II
    1 year ago

    Yes, but the thing is that it works for English culture, but for Spanish culture (with the European number format) it doesn't work

    • KarlT's avatar
      KarlT
      Icon for OneStream Employee rankOneStream Employee
      1 year ago

      I don't see why it would only work for English culture. i just tested with French culture on my machine and it worked as i would expect.

      • daniel's avatar
        daniel
        New Contributor II
        1 year ago

        And how could you get the number format like this:

        3.333.333,25

        (3.333.333,25)