Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
my function is as follows:
=Concat(DISTINCT Month, ', ')
Be default the result is sorted in an alphabetic order - from A to Z.
I'd like to sort it by load order, so that Jan should come first.
I've found out the general description. It is possible to add a sort_weight.
concat([{set_expression}] [ distinct ] [ total [<fld {, fld}>]] expression[, delimiter[, sort_weight]])
But how exactly can define that sort_weight should equal load order?
Thank you in advance,
Larisa
Yup, I forgot to put the single quotes around it. Glad you caught my error