Thursday
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,
Thursday
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:
Friday
Yes, but the thing is that it works for English culture, but for Spanish culture (with the European number format) it doesn't work
Friday
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.
Friday
And how could you get the number format like this:
3.333.333,25
(3.333.333,25)