Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

IF

Hi All, I would like to create a calculated column using IF. I am not sure how to use multiple Logical test. For eg: I have a set of locations. And each location belong to a certain region. It ...

Need Help

Samarth_18

5 years ago

Hi Anonymous ,

You can try below code:-

Region =
IF (
    LOCATION[Location] IN { "PL60", "MA81", "MA82" },
    "EMEA",
    IF ( LOCATION[Location] IN { "2201" }, "APAC", "NA" )
)

Thanks,

Samarth

Samarth_18

Community Champion

5 years ago

Hi Anonymous ,

You can try below code:-

Region =
IF (
    LOCATION[Location] IN { "PL60", "MA81", "MA82" },
    "EMEA",
    IF ( LOCATION[Location] IN { "2201" }, "APAC", "NA" )
)

Thanks,

Samarth

Anonymous

Not applicable

5 years ago

Thank you so much! Samarth_18