CODEWITHSUNDEEP
stylesformatbirtnegative-number
Manikandan Arunachalam
Manikandan Arunachalam

Reputation: 1500

How to set bracket to negative value but '-' should not be visible in birt report?

I am using birt 4.4.1, and designing in eclipse. I am in a situation where i need to show a number enclosed by bracket if it is negative and also the "-" sign should not be shown(as we can do in microsoft excel). Is this possible in birt report?

Upvotes: 0

Views: 956

Answers (1)

Dominique
Dominique

Reputation: 4342

Select your data item -> properties -> Format number -> custom

In "Format code" field enter two patterns separated by a semi-colon. The first pattern is for positive numbers, the second one for negative. For instance this pattern is a percent format, with brackets surrounding negative values. 

0.0%;(0.0%)

Upvotes: 3

Related Questions