Remove line from the code

[sdhn]

Hi All,

I have existing calculalted column code as below:

Graphs =

SWITCH(

TRUE(),

[Vulnerable (Yes/No/Not Assessed)] = "NOT ASSESSED"

|| [Vulnerable (Yes/No/Not Assessed)] = "UNKNOWN", "NOT ASSESSED",

[Vulnerable (Yes/No/Not Assessed)] = "YES"

|| [Vulnerable (Yes/No/Not Assessed)] = "NO", "ASSESSED"

Now there is no value for UNKNOWN. we need to remove UNKNOWN from the code. 

Logic one should be "NOT ASSESSED is NOT ASSESSED".  Rest os fine.

I removed this row  || [Vulnerable (Yes/No/Not Assessed)] = "UNKNOWN", "NOT ASSESSED",   but getting errors.

help will be appreciated.  Thanks 

[sdhn]

Thanks 

[VahidDM · Accepted solution]

Hi @sdhn 

Try this:

Graphs =
SWITCH (
    TRUE (),
    [Vulnerable (Yes/No/Not Assessed)] = "NOT ASSESSED", "NOT ASSESSED",
    [Vulnerable (Yes/No/Not Assessed)] = "YES"
        || [Vulnerable (Yes/No/Not Assessed)] = "NO", "ASSESSED"
)

or 

Graphs =
IF (
    [Vulnerable (Yes/No/Not Assessed)] = "NOT ASSESSED",
    "NOT ASSESSED",
    "ASSESSED"
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/