Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What if Year is number and Class is text?
I would use this
Rank(Class) + (Year/1E10)
Doesn't do the trick =(
Share an example?
Hi stalwar1 and Happy New Year!
Here is an example. Pay attention to the concat field
Have found the following way to resolve this:
Aggr(NODISTINCT rowno(),Class) + (Year/1E10)
That is great