Eclipse Community Forums: BIRT » Replace zero values with a custom string in a table with aggregated values ...

Help

Home

Home » Archived » BIRT » Replace zero values with a custom string in a table with aggregated values ...

Show: Today's Messages :: Show Polls :: Message Navigator

Replace zero values with a custom string in a table with aggregated values ... [message #1828445]

Tue, 09 June 2020 22:11

Catalin Florean

Messages: 2
Registered: June 2020

Junior Member

Hi All,

In one of my reports, I'm trying to reproduce an Excel custom number formatting:

### ### ### ##0;-### ### ### ##0;"p.m."

In Excel this rule displays all ZERO values as the string "p.m.".

I tried the custom format string in the "Format number", custom settings. It does not work.

In my report I need to present the ZERO (0) values as the string "p.m." and at the same time my aggregation sum on this column should still work (no conversion errors).

For example, in my column I have the values
10
20
0
30
0
40
Total aggregation = 100

In my report I need to display this:
10
20
p.m.
30
p.m.
40
Total aggregation = 100

Any ideas or suggestions are welcome.

Thank you!

Report message to a moderator

Re: Replace zero values with a custom string in a table with aggregated values ... [message #1828468 is a reply to message #1828445]

Wed, 10 June 2020 10:44

Catalin Florean

Messages: 2
Registered: June 2020

Junior Member

Hi All,

I found a solution.
As I was only needing to display zeros (0) as "p.m" visually, I used the OnRender event of the cell element. The code below did the trick:

var newval=this.getValue().toString(); if (newval==0) {this.setDisplayValue("p.m.")}

Report message to a moderator

Previous Topic:	Page Break based on row count of two Tables
Next Topic:	How birt handles Khmer text

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 16:52:31 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter