Avg Rank Aggr Sum for the Average of Ranks

[Oskar_vl]

Hi,

is it posible to take the average of ranked values.

This doesn't work:

(The light itself works fine, it is the Rank column in the picture)

avg(
Rank(aggr((sum(Value1)/sum(Value2))
,Dim1,Dim1,Dim1),4,2)
)

This I need:

Best regards

[sunny_talwar]

May be this

Avg(TOTAL <Dim1> Aggr(
    Rank(Sum(Value1)/Sum(Value2))
, Dim1, Dim2, Dim3))

[Oskar_vl]

Unfortunately not

without the <Dim1> I get a result but the wrong one.

And when I insert the Rank parameters ",4,2" there is again no result.

[sunny_talwar]

Would you be able to share a sample where we can see the issue?

[Oskar_vl]

I am sorry, I can't share the data.

[sunny_talwar]

no problem