Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Year-to-date function with missing values
Year-to-date function with missing values [message #1073175] Wed, 24 July 2013 05:11 Go to next message
donino donino is currently offline donino donino
Messages: 162
Registered: July 2011
Senior Member
Hi,

We use a "relative time periods" Year-To-date function with Eclipse designer 4.3:

index.php/fa/15680/0/

This feature is awesome but we face to a problem when a month return no data in a cell. In the crosstable picture attached making use of the sample database, property "For empty cells, show" is set to "0". We can see there is no data for "Motorcycle" in march, though year-to-date should return the same value as february (953), not 0. This is not the expected behavior in charts, and it makes Total by month inconsistent with the sum of rows: in march, the total is 8694 which is the expected value. But the sum of rows is 7741, because the motorcycle value 953 is missing.

index.php/fa/15681/0/

It seems to be the same with all other functions such "Trailing N month" or "Current Year"

Please could you help? Is there any tip to force relative time periods calculations even for empty months?

Thanks!

[Updated on: Wed, 24 July 2013 05:15]

Report message to a moderator

Re: Year-to-date function with missing values [message #1075317 is a reply to message #1073175] Mon, 29 July 2013 04:18 Go to previous messageGo to next message
donino donino is currently offline donino donino
Messages: 162
Registered: July 2011
Senior Member
I tried every datacube/crosstab option, nothing helped. I also tried to use a derived measure to return 0 when missing, but relative time periods don't work on a derived measure.

I found a workaround through scripts, by injectings rows with a 0 value for the first day of each month, for each product line. That's quite tricky, i believed it is the kind of thing "relative time periods" was supposed avoid doing. But it works...

index.php/fa/15743/0/

[Updated on: Mon, 29 July 2013 04:26]

Report message to a moderator

Re: Year-to-date function with missing values [message #1075668 is a reply to message #1075317] Mon, 29 July 2013 16:56 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1547
Registered: July 2009
Senior Member

Glad you found a solution. You might log a bug for this.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:How to ?
Next Topic:Show Header only on first page BIRT
Goto Forum:
  


Current Time: Wed Jul 30 13:26:07 EDT 2014

Powered by FUDForum. Page generated in 0.07299 seconds