Why Count List become Zero

[ADAJALAN]

Why, Count zero ?

Select(Report Interactive[ID],
AND(
In([BANGUNAN / PEKERJAAN],Select(FILTER[Pekerjaan],true)),
In([PERUSAHAAN],Select(FILTER[Perusahaan],true)),
In([JOB SITE],Select(FILTER[Site],true)),
In([Status],Select(FILTER[Status],true))
)
)

[Aurelien]

Hi @ADAJALAN 

I think your expression is incorrect, it looks like a bug to me.

If I may, here is a slight improvement for your expression:

FILTER("Report Interactive",
  AND(
    IN([_THISROW].[BANGUNAN / PEKERJAAN],FILTER[Pekerjaan]),
    IN([_THISROW].[PERUSAHAAN],FILTER[Perusahaan]),
    IN([_THISROW].[JOB SITE],FILTER[Site]),
    IN([_THISROW].[Status],FILTER[Status])
  )
)

[ADAJALAN]

Thanks @Aurelien 

But , when I Applied your expression :

and when i modify ,,like this :

FILTER("Report Interactive",
AND(
IN([BANGUNAN / PEKERJAAN],FILTER[Pekerjaan]),
IN([PERUSAHAAN],FILTER[Perusahaan]),
IN([JOB SITE],FILTER[Site]),
IN([Status],FILTER[Status])
)
)

Result count zero :

[Aurelien]

I would suggest to read this documentation:

https://support.google.com/appsheet/answer/10108196?hl=en

You will notice your expression must have a [_THISROW] expression inside. 

From the error you show, I think there is a mismatch: the table in which you use this expression must have the column [BANGUNAN / PEKERJAAN]

[ADAJALAN · Accepted solution]

Oke thanks,

I made a few modifications, and it worked

FILTER("Detail Report Project",
AND(
IN([BANGUNAN / PEKERJAAN],[_THISROW].[Pekerjaan]),
IN([PERUSAHAAN],[_THISROW].[Perusahaan]),
IN([JOB SITE],[_THISROW].[Site]),
IN([Status],[_THISROW].[Status])
)
)

[Uk]

SELECT(
Report Interactive[ID],
AND(
IN([BANGUNAN / PEKERJAAN], SELECT(FILTER[Pekerjaan], TRUE())),
IN([PERUSAHAAN], SELECT(FILTER[Perusahaan], TRUE())),
IN([JOB SITE], SELECT(FILTER[Site], TRUE())),
IN([Status], SELECT(FILTER[Status], TRUE()))
)
)