Order of concatination

[Anonymous]

Hi,

I have a function that creates a string based on the results of the adjacent field via concatination. But, the issue is that the order is not preserved at the end.

Using this formula :

=Concat(TOTAL <School, Class> Aggr(If(Excellent > Good, 'yes', 0), Year, School, Class), '|')

Output is like:

Normaly, the result should be "yes|0|yes", but its "0|yes|yes".

Is it possible to somehow resolve this issue?

updated formula due to wrong field existence

[Anonymous]

What if Year is number and Class is text?

[sunny_talwar]

I would use this

Rank(Class) + (Year/1E10)

[Anonymous]

Doesn't do the trick =(

[sunny_talwar]

Share an example?

[Anonymous]

Hi stalwar1‌ and Happy New Year!

Here is an example. Pay attention to the concat field

[Anonymous]

Have found the following way to resolve this:

Aggr(NODISTINCT rowno(),Class) + (Year/1E10)

[sunny_talwar]

That is great