Forum Discussion
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)] = "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
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/
2 Replies
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/Thanks
