Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Switch Column Logic Help

Hi All,   I'm in a pickle. I have the below logic using 3 columns on the same table:   Label = Switch( True(), ActiveHC[Country Name] = "Turkey", "Cars", ActiveHC[Country Name] = "Greece", "C...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous - Does this work?:

Label =
SWITCH(
    TRUE(),
    ActiveHC[Country Name] IN { "Turkey", "Greece", "Italy" }, "Cars",
    ActiveHC[Layer 2] IN { "Beth", "Joanie", "Dan", "Bill", "Christina" }, "Corporate",
    ActiveHC[Layer 2] = "Steven", "Cars",
    ActiveHC[Layer 2] = "Bobby", "Audio",
    ActiveHC[Layer 2] = IN { "Matt", "Peter", "Edward" }, "Photos",
    ActiveHC[Layer 2] = "Joey", "Software",
    ActiveHC[Business Unit] = "Cameras", "Cameras",
    BLANK()
)

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for this, but it will not work. That's a standard SWITCH which I can do, I'm trying to make it so the COUNTRY is the default return if it is NOT one of those countries, then return the other switch function.