Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 367624 - Some aggregation functions (quartile, percentile) throw AggrException when all values are filtered
Summary: Some aggregation functions (quartile, percentile) throw AggrException when al...
Status: VERIFIED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: PC Linux
: P3 normal (vote)
Target Milestone: 3.7.2   Edit
Assignee: Zhang Lei CLA
QA Contact: Hao Zhou CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-12-29 08:15 EST by Michal Tkacz CLA
Modified: 2012-03-16 02:20 EDT (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michal Tkacz CLA 2011-12-29 08:15:52 EST 
Build Identifier: 3.7.1.v20110905

Aggregate functions like QUARTILE or PERCENTILE throw AggrException when all values are filtered using Filter Condition (no value is left to calculate aggregate value). Other aggregate functions like AVG or MEDIAN return null in this case, which IMHO is the correct behaviour. 

Data (id = 87):
+ A BIRT exception occurred. See next exception for more information.
Not all the values for percentile can be null. (Element ID:87) 


Reproducible: Always

Steps to Reproduce:
1. Create a table based on a non-empty data set of your choice
2. Put QUARTILE aggregation in the header/footer and set Filter Condition so that all values are filtered out.
Comment 1 Zhang Lei CLA 2012-03-16 02:16:30 EDT 
return null value when getting the summary value for these functions. fix this issue.
Comment 2 Hao Zhou CLA 2012-03-16 02:20:40 EDT 
Verified.