Forum Discussion

daniel's avatar
daniel
New Contributor
10 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 how can I customize the format for that because N1 is not an option because the negative numbers appear with a minus.

Thanks,

5 Replies

  • T_Kress's avatar
    T_Kress
    Valued Contributor

    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

      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

        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.