Bug 284979

Summary:	Support Value argument in PERCENTRANK
Product:	z_Archived	Reporter:	Tianli Zhang <tzhang>
Component:	BIRT	Assignee:	Mingxia Wu <mwu>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	P3	CC:	lzhu, wenfeng.fwd
Version:	unspecified	Keywords:	plan
Target Milestone:	Future
Hardware:	PC
OS:	Windows XP
Whiteboard:

Description Tianli Zhang

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