Forum Discussion

Shree_185's avatar
Shree_185
Icon for Helper I rankHelper I
4 years ago
Solved

SLA Switch Statements Error - Text and number datatype not supported, use Value or Format

TextTextDecimal NumberText
SeverityCalc Severity Time Spent Customer Reasons
Severity 118.4HW/SW
Severity 222.3Customer awaiting
Severity 335.8 
Severity 446.4 
Severity 553.4 
Severity 663.2 

 

 

I want to write 9 - 10 If Else, so thinking to go with Switch. I get error text and number datatype not supported, use value or Format function for one of them

Example If Severity = 2 OR Severity = 3 && Time Spent > 10 , "flag"
If Severity = 3 && Time spent > 4 && Customer Reason!= "HW/SW","Flag","Good"

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Since severity is a text column, you need to check it accordingly.

     

    Try this as a calculated column:

    SWITCH (
    TRUE (),
    Table1[Severity] IN { "2", "3" } && Table1[Time Spent] > 10, "flag",
    Table1[Severity] = 3 && Table1[Time spent] > 4 && Table1[Customer Reason] <> "HW/SW", "Flag",
    "Good"
)

1 Reply

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    Since severity is a text column, you need to check it accordingly.

     

    Try this as a calculated column:

    SWITCH (
    TRUE (),
    Table1[Severity] IN { "2", "3" } && Table1[Time Spent] > 10, "flag",
    Table1[Severity] = 3 && Table1[Time spent] > 4 && Table1[Customer Reason] <> "HW/SW", "Flag",
    "Good"
)