Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey all,
I have a problem with the sort weight in a concat distinct expression.
First I just used the expression without the sort weight:
FirstSortedValue({<filters>}Person,-Date,1) & ' (' & concat(distinct {<filters>}Country,'/') & ')'
That works fine, except that the fields are ordered by alphabetical order. But when I add a sort weight with Date (nummerical version of date) the expression ignores the distinct line in the concat.
Is this a known issue?
Hello,
I am facing the same issue.
When using sort-weight argument DISTINCT seems to be ignored.
Did you find any solution for this?
Thank you,
Pedro
I'm having this same issue. Trying to Concat the Distinct values with the order based on an Amount
Concat(DISTINCT GL_CC_CODE_src_1,';',AMT_NET_TAXREP_src_1) As GL_CC_CODE_src_3
This works fine if I leave off the sort weight i.e. AMT_NET_TAXREP_src_1
But if I have the Sort Weight the distinct does not work.