*-value

[bobbydave]

= aggr(if(rank(avg([Metric Value]))<=6,Grouping),Year,[Cost Center])

I am creating a ranking system and the above equation resolves this.

However, there is one value in Grouping that I do not want in the equation called 'Cost'

= aggr(if(rank(avg([Metric Value]))<=6,Grouping='*@-'Cost'),Year,[Cost Center])

Obviously the 2nd equation is incorrect.

Anyone know how i would rewrite this to allow for Grouping to remove 'Cost'?

Thanks

[alexandros17 · Accepted solution]

Try with

aggr(if(rank(avg([Metric Value]))<=6,If(Grouping<>'Cost', Grouping, Null())),Year,[Cost Center])

[Gysbert_Wassenaar]

= aggr(if(rank(avg([Metric Value]))<=6 and Grouping <> 'Cost',Grouping),Year,[Cost Center])

[bobbydave]

Thanks guys

[bobbydave]

Thanks guys