Problem trying emulate Custom Report APP

[Devina_Maxwell]

I am trying to emulate the Sample APP custom Reports
I cannot seem to get the Virtual Matching column listing the items I want it just shows the first item that matches?

The only difference I notice is that I cannot change the TYPE DETAILS Element type to Ref.

it just keeps going back to text . The column Data type is List.
This is my expression in the virtual column
SELECT(Daily Record ไดอารี่[Scan], (IN([Date], [_THISROW].[Date Choice])))

[Aleksi]

Is your [Date Choice] column’s type “Date”? If yes, the IN expression is not the correct choice. You can use just [Date]=[_THISROW].[Date Choice]

[Steve]

The first argument should be a single value, the second should be a list.

help.appsheet.com

IN()

Is item in list?