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,

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:

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

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.

Sign up