Bug 284979 - Support Value argument in PERCENTRANK
Summary: Support Value argument in PERCENTRANK
Status: NEW
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: Future   Edit
Assignee: Mingxia Wu CLA
QA Contact:
URL:
Whiteboard:
Keywords: plan
Depends on:
Blocks:
 
Reported: 2009-07-29 04:56 EDT by Tianli Zhang CLA
Modified: 2010-05-06 03:05 EDT (History)
2 users (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 Tianli Zhang CLA 2009-07-29 04:56:11 EDT 
Description:
For current PERCENTRANK in BIRT it is a running aggregation and it will calculate the percent rank of the value in current row. But we can not cover one case, I want to know the percent rank of a constant value in each group. In Excel, PERCENTRANK(array,x,significance) has three arguments, X is the value for which you want to know the rank. I suggest to support this argument in PERCENTRANK, if x argument is specified, the Aggregation is a non-running aggregation and just calculate the percent rank of the specified value.

Build number: 
2.5.1.v20090729-0630