Forum Discussion
Solved
Try using Switch but got error: A table multiple values was supplied where a ...
Hello, im trying making a column using Switch function, got this error: "A table of multiple values was supplied where a single value was expected" and i don't know how to resolve it. Does anyone ha...
Hi, uif19085
You can try the following methods.
Severity = SWITCH(TRUE(), NOT([SIL]) in {"QM","#TBD#"}, "ASIL", [SIL]<>BLANK() && [Test_Severity] = "top","top", [SIL]<>BLANK() && [Test_Severity] = "high","high", [SIL]<>BLANK() && [Test_Severity] = "medium","medium", [SIL]<>BLANK() && [Test_Severity] = "low","low", [SIL]<>BLANK() && [Test_Severity]<>BLANK(),"Not Assigned")Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, it works, but had to replace every "<>" with "="
Hi, uif19085
You can try the following methods.
Severity =
SWITCH(TRUE(),
NOT([SIL]) in {"QM","#TBD#"}, "ASIL",
[SIL]<>BLANK() && [Test_Severity] = "top","top",
[SIL]<>BLANK() && [Test_Severity] = "high","high",
[SIL]<>BLANK() && [Test_Severity] = "medium","medium",
[SIL]<>BLANK() && [Test_Severity] = "low","low",
[SIL]<>BLANK() && [Test_Severity]<>BLANK(),"Not Assigned")
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, it works, but had to replace every "<>" with "="