Forum Discussion

daniel's avatar
daniel
New Contributor
3 months 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
Contributor III
3 months 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
    3 months 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
      Contributor III
      3 months 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
        3 months ago

        And how could you get the number format like this:

        3.333.333,25

        (3.333.333,25)