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
Solved! Go to Solution.
Great! That's something I needed. I updated the formula, so at the end it should be:
=Concat(TOTAL <School, Class> Aggr(If(Excellent > Good, 'yes', 0), Year, School, Class), '|',Year)
Yup, the only thing with that post is that there are gaps in the year. so, it goes from 2011, 2012 to 2014... so I am not sure if just concat will work... but yes, it is def. an option
stalwar1, I have one addition. What if the class field is conditional. Is it possible somehow to adapt the concatenation that in case of disabling the class field, it adapts for the <school, year>?