Rank question

[#1]

Hello all,

Could you please help me on the below problem that I have when I am trying to use the Rank formula.

I have the below report: where the test formula looks like this:

Test formula:

=Rank(([vdConcatenate]); ([Project Definition. -Key]); [Milestone Usage - Key]); ([Project Definition. -Key])

When I add the last part Project Definition. -Key (which is the dimension to reset the ranking) I got the below error message.

I am expecting to see the below behaviour

That means that I need to rank when the project changes and I not getting this.  Please help me.  

Thanks.

Iliana

[Former Member · Accepted solution]