Need help

[gireesh1216]

Hello Team,

I have a table like below:

ID	SID	MID
1216	1217	1218
1219	1222	1223
1220	1222	1223
1221	1224	1225
1222	1217	1218
1224	1223	1218
1225	1223	1218
1218	1223	1225
1223	NULL	1225

OUTPUT: If I select 1218 from ID field I WANT OUTPUT LIKE BELOW:

EXPRESSION:CONCAT({1<SID=P(ID)>}ID)

ID	SID	MID	CONCAT({1<SID=P(ID)>}ID)	COUNT
1218	1223	1225	1217,1223	2

[tresB]

May be this?

CONCAT(Distinct {1<MID=P(ID)>}SID, ',')

[gireesh1216]

Hello Tresesco,

Thanks for ur reply,

I am getting CONCAT(Distinct {1<MID=P(ID)>}SID, ',') and COUNT fieldS but not getting SID and MID values.

[tresB · Accepted solution]

PFA

Try with 'Total'

=Concat( Total Distinct {1<MID=P(ID)>}SID, ',')

[gireesh1216]

Thank you so much:)