concatinating 2 values from the same field

[apthansh]

Hi - I have below exprressons working ....

max({<[Yes_No]={'Yes'},Date={'<=$(=Date(Today()))'}>}Date)

FirstSortedValue({$<[Yes_No]={'Yes'}>} Name, -if(Date<Today(),Date))

but now I want to concatenate values from the same field..I have below expression, but no luckk

aggr(concat(max{<[Yes_No]={'Yes'},Date={'<=$(=Date(Today()))'}>}Date, ',') ,ID)

aggr(concat(FirstSortedValue{$<[Yes_No]={'Yes'}>} Task, -if(Date<Today(),Date))Date, ',') ,ID)

Any thoughts please

[tresesco]

Try putting concat() outside aggr(), like:

Concat(Aggr(max{<[Yes_No]={'Yes'},Date={'<=$(=Date(Today()))'}>}Date, ID) , ',')

Concat(Aggr(FirstSortedValue{$<[Yes_No]={'Yes'}>} Task, -if(Date<Today(),Date))Date, ID) , ',')