Calculated Field Not Working on WHERE clause

[KateyN]

Hi! I have a details page where I am trying to list names of participants in enrolled in a group. I have the following calculated field, but instead of only showing the names associated with the Group_ID, it's listing all of the names in the table. Can anyone point me into where I am potentially going wrong here?

SELECT 
   
  Participant_Name= STUFF((SELECT DISTINCT CHAR(10) + (Participant_Name)
                 FROM FSE_Groups_Topics_Participants
                 WHERE Group_ID = [@field:Group_ID]
                 FOR XML PATH('')), 1, 1, '')

[CoopperBackpack]

Hello @KateyN,

The syntax looks correct to get the names related to the specific group.

Please test the formula with the added 'target' keyword. It is not SQL specific keyword but Caspio-specific.

STUFF((SELECT DISTINCT CHAR(10) + (Participant_Name)
                 FROM FSE_Groups_Topics_Participants
                 WHERE Group_ID = target.[@field:Group_ID]
                 FOR XML PATH('')), 1, 1, '')

Also, please double-check if this field name is correct [@field:Group_ID].

If this doesn't help, please specify the 'Form element' of the Group_ID field used on the Details DataPage.

Is it editable or 'Display only'? Is it a Dropdown, etc. (if it is editable)? 

Does it receive the Group_ID value as a parameter? 

Also, instead of the Calculated field please test a Virtual field that is set as a Calculated value.

[KateyN]

That worked!! Thank you!!