Solved: Filtering based on the desired value from a refere... - Page 2

yasarcan · 06-29-2024 06:24 AM

12

Hello, I am a search and rescue volunteer. I need an application that can count and list volunteers entering and exiting the disaster area. I got the counting part done, but I'm having trouble creating a list. Can you please help me with this? Thank you!

SELECT(güvenlik[Gönüllü adı], 
AND([Durum] = "GİRİŞ", [maps id] = LOOKUP([_THISROW], "güvenlik", "maps id", "maps id")))

I can filter and count based on the desired value using this formula. However, I'm having trouble excluding entries where the [Durum] = "ÇIKIŞ". I created two virtual columns for entry and exit and listed them separately. Then I tried another virtual column, but still couldn't solve it. What is your suggestion? (DURUM=STATUS, GİRİŞ=ENTER, ÇIKIŞ=EXİT; turkish)

yasarcan

INTERSECT(
INTERSECT(
SELECT(güvenlik[Gönüllü adı], [Durum] = "GİRİŞ"),
SELECT(güvenlik[Gönüllü adı], [maps id] = [_THISROW].[MapKey])
),
INTERSECT(
SELECT(güvenlik[Gönüllü adı], [Durum] = "ÇIKIŞ"),
SELECT(güvenlik[Gönüllü adı], [maps id] = [_THISROW].[MapKey])
)
)

View solution in original post

Filtering based on the desired value from a reference table.