Webi Decimal Formula (#,.00) Question
I use #0,.00 formula to get the decimal value for two digit after comma. But when I export report to Excel, it looks like 2943,00.
I want to see it like 2.943,00. I mean that I should see the point sign as well as comma.
How can I get 2.943,00 format when I export it to Excel?
you need to format as "#,###.00".The decimal point can´t be used to represent the decimal and thousand separator. And choose , on Web Intelligence Preferences at BI Launch PAD the preference at
|Select a priority for saving to MS Excel:|