The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
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...
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
OneStream Employee
OneStream EmployeeI 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.
And how could you get the number format like this:
3.333.333,25
(3.333.333,25)
- KarlT
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]