negative number format

Question

Hi,I'm trying to set the number format&nbsp;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,

T_Kress · Answer

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:

&nbsp;

daniel · Answer

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 · Answer

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 · Answer

And how could you get the number format like this:3.333.333,25(3.333.333,25)

KarlT · Answer

something like this (havent tested it) - you have to use the "english" culture format in the cube view and it will convert appropriately to whatever culture your user is when running the cube view.
NumberFormat = [#,###,0.00;(#,###,0.00);0.00]
&nbsp;

Forum Discussion

negative number format

5 Replies

Related Content

Can you get Cube View cell number formatting to display/accept European number formatting?

Apply regional settings number format in Onestrem

XFCell number format issue in People Planning Solution

Show Report formatting

Data Load showing negative number