Linear guage Max value

[#1]

Hi again

This is baffling me.  I have this SUM formula that works in my model:

sum({<Group = {'$(=Concat(if(aggr(rank(sum([PO count])),Group)=1,Group,null()), chr(39) & ',' & chr(39)))'} >} [PO count]) * 1.02

However, the COUNT equivalent is giving me problems.

I have created a small demo (attached) to show you more detail.

Any help is as usual very appreciated.

Oli

[Clever_Anjos · Accepted solution]

you need an extra ')'

=count(

{<Type={'$(=concat(if(aggr(rank(count(distinct Supplier)), Type)=1,Type,null())))'}

>}

distinct Supplier) * 1.02

[#3]

Thank you