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

Input form should not allow negative values

Data Load showing negative number