Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Year-to-date function with missing values
Year-to-date function with missing values [message #1073175] Wed, 24 July 2013 09:11 Go to next message
donino donino is currently offline donino doninoFriend
Messages: 183
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 09: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 08:18 Go to previous messageGo to next message
donino donino is currently offline donino doninoFriend
Messages: 183
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 08: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 20:56 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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

Michael

Developer Evangelist, Silanis
Previous Topic:How to ?
Next Topic:Show Header only on first page BIRT
Goto Forum:
  


Current Time: Thu Mar 28 08:11:31 GMT 2024

Powered by FUDForum. Page generated in 0.03306 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top