rank expr explination?

Sun, 09 Nov 2014 08:04:07 GMT

=IF (aggr(rank( sum(Value) ,0) , Value )<= 5 , sum(Value) )

how it is calculating pls explain me step by step?

Re: rank expr explination?

ashfaq_haseeb — Sun, 09 Nov 2014 08:32:39 GMT

Hi,

Go through this attached application yo will understand.

Regards

ASHFAQ

MK_QSL — Sun, 09 Nov 2014 17:34:11 GMT

=IF (aggr(rank( sum(Value) ,0) , Value )<= 5 , sum(Value) )

Lets Start From the Inside Function First

SUM(Value) : Sum of Value

Rank(SUM(Value) ,0) : This will allocate Rank against each SUM(Value)

Aggr(Rank(SUM(Value) ,0)) : This will create a Virtual Table as below format. (Dummy values are given for your understanding)

SUM(Value) Rank

100 1

95 2

80 3

etc...

Now

IF (aggr(rank( sum(Value) ,0) , Value )<= 5 : will check that which are the lines from above Virtual Table falls (Rank <=5)

Whatever SUM(Value) is having Rank <=5 , will only be displayed...

Let us know if this is still not clear...