Aggr Rank function

[rtrochim]

Hi,

I am looking for a simple solution to combine two columns with with rank function. At the moment both columns are based on "rank" function". As a result it will be total rank based on rank values. Here is the syntax I am using at the moment and the result is "-" no values at all. Any ideas how to fix that?

=(Aggr(rank(Aggr(rank(total Sum(Metric 1),4,0)))+(Aggr(rank(total count(Metric2),4,0))),4,0))

Regards

Rafal