CODEWITHSUNDEEP
pentahopentaho-report-designer
user8194328
user8194328

Reputation:

Pentaho: How to replace commas with dots and vice versa(format)

I want to change in number-field format, commas with dots and dots with commas. Thanks in advance!

VALUE 9,795.00

What I used to format number ###,###,###.00

And I want it to be like: 9.795,00

Upvotes: 0

Views: 1062

Answers (1)

user8194328
user8194328

Reputation:

At the end I left formation like it is (###,###,###.00), because formatting depends on localization. I will set hardcoded localization value through java and when calling report it will forward french or german localization.

Upvotes: 1

Related Questions