undefined

[Anonymous]

Create a calculated column in Job Table as "Status Colour Code" where Job Status = "SUCCESS" should be 1, "FAILED" should be 2, "CANCELLED should be 3"

[TheoC]

Status Colour Code =

SWITCH (
    TRUE () , 
         Job Table[Job Status] = "SUCCESS" , 1 ,
         Job Table[Job Status] = "FAILED" , 2 ,
         Job Table[Job Status] = "CANCELLED" , 3 )

@Anonymous  Hope this is what you're after 🙂 

[Anonymous]

Thank for your reply.

But it did not work and I am facing an error

[TheoC · Accepted solution]

You may need to write the table as 'Job Table' rather than Job Table.

[amitchandak]

@Anonymous , a new column

Status Colour Code = Switch ( Job Status,

"SUCCESS" , 1,

"FAILED" , 2,

"CANCELLED , 3

)