|Year-to-date function with missing values [message #1073175]
||Wed, 24 July 2013 09:11
| donino donino
Registered: July 2011
We use a "relative time periods" Year-To-date function with Eclipse designer 4.3:
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.
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?
[Updated on: Wed, 24 July 2013 09:15]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.02022 seconds