Formula in view error

Hello,

I'm using the formula field in a view to select only a group of realtors in my system.

Realtors are coupled to groups, and users that can log in are coupled to these groups. I want realtors to be only visible to users that are in the group that is assigned to this realtor. To do this I'm using this code in the formula: 

R115171597 IN ( SELECT id, name FROM $GROUP WHERE R2354869 = {!#CURR_USER.id} )

This however gives me an error when open this view: 

Error: Error in SQL Query ListView=108173991 SELECT COUNT(A.OBJ_ID) FROM RB_OBJ_DATA A WHERE A.OBJ_DEF_ID=108173935 AND (A.INTG9 IN ( SELECT A.OBJ_ID, A.OBJ_NAME FROM $GROUP WHERE R2354869 = 108173687 ) ) Table 'rb_cust4.$group' doesn't exist

What am I doing wrong? Thanks in advance