Text object properties - max number and name

[knightwriter]

Hi All,

What formula / expression do I use to make my text object show the max number and the equivalent subject / name?

Many thanks.

[rubenmarin]

Hi Stephen, can you post an example of the data and which results are you expecting?

A simple text explanation will be enough

[knightwriter]

Hi Ruben,

So I have quite a lot of activities and I want the text object to show the sum of the highest activity, along with the activity name only.

Does this explain?

[rubenmarin · Accepted solution]

It can be something like:

=Aggr(If(Rank(Count(ActivityName))=1, ActivityName & ': ' & Count(ActivityName)), ActivityName)

[knightwriter]

Beautiful! Just beautiful