using aggr to give me least values

[Anonymous]

Hello,

I currently have the following expression to rank the top five values in a field

=concat(distinct IF(aggr(rank(sum(Field1)),[Field2])<=5,[Field2]), CHR(13),-aggr(sum([Field1]),[Field2]))

However, I am looking to get a text object to show the opposite with the smallest 5 values in a field. Any ideas of how to tweak the function to show that?

Thanks

[sunny_talwar]

Try this maybe:

=Concat(Distinct If(Aggr(Rank(-Sum(Field1)),[Field2])<=5,[Field2]), CHR(13),-Aggr(-Sum([Field1]),[Field2]))

Best,

Sunny

[Gysbert_Wassenaar]

Multiply sum(Field1) by -1: rank(-sum(Field1))

[Anonymous]

Thanks, but this produced a lot more than 5 values

[Anonymous]

Appears to be similar to what is mentioned above and is producing a lot more than the 5 values I am trying to limit it to

[sunny_talwar]

Do you have a lot of 0's in your aggregated Field1 may be?? If you that's true the rank of all 0 will be 1 and will show up in the minimum.

Best,

Sunny