What is wrong in my dataview formula ? im trying to capture 4 variable + the case where its undefined or not set
IFS(
"BRAND" in site_info__brand and "COUNTRY" in site_info__country, "BRAND COUNTRY",
"BRAND" in site_info__asset_brand and "COUNTRY" in site_info__asset_country, "BRAND COUNTRY",
"not set" in site_info__brand or "not set" in site_info__country, "not set BRAND COUNTRY Event",
"not set" in site_info__asset_brand or "not set" in site_info__asset_country, "not set BRAND COUNTRY Event",
UNDEFINED(site_info__brand) or UNDEFINED(site_info__country), "not set BRAND COUNTRY Event",
UNDEFINED(site_info__asset_brand) or UNDEFINED(site_info__asset_country), "not set BRAND COUNTRY Event"
)