filter operation

[Adolfo_Enrique_]

I am telling you that I am trying to show the detail of a mobile phone that is assigned to a work team. For this, within the EquipoMoviles,

I have created a column where I keep a collection of mobiles IdMoviles. In another table called Moviles, I keep the detail of the mobiles.

Now I have created a virtual column where I use the following formula to filter the detail of each mobile in said collection. This is the formula FILTER (Moviles, IN([Identificacion],SPLIT([IdMoviles], " , ")))

but I cannot visualize in the virtual Mobile column the information obtained from the previously detailed formula.

Please tell me if I'm making a mistake? and how should i solve it? Thank you so much

[Rafael_ANEIC-PY]

Your virtual column should be of type ENUMLIST type REF to the table you're filtering from, not text.