Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
4 years ago
Solved

Remove line from the code

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)] = "UNKNOW...
  • VahidDM's avatar
    4 years ago

    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/