if clause

[Anonymous]

I want to add severity=4 and 40 hours for that

if(Severity=1,3,if(Severity=2,5,if(Severity=3,24,'No_SLA'))) as KPI_TIME,

[sunny_talwar]

May be this:

If(Severity=1, 3,

If(Severity=2, 5,

If(Severity=3, 24,

If(Severity=4, YourNumber, 'No_SLA')))) as KPI_TIME,

[nagaiank]

Did you try

if(Severity=1,3

,if(Severity=2,5

,if(Severity=3,24

,If(Severity=4,40,'No_SLA')))) as KPI_TIME

[maxgro]

a different one

pick(wildmatch(Severity,1,2,3,4, '*'), 3, 5, 24, 40, 'No_SLA')  as KPI_TIME