Filtering out field data in separate from a particular field

Hi Team,
I want to retrieve a particular data in a field by using if-else condition statement. So how can I do that?
PFB for your reference
Lets say here, I want to retrieve below field data in separate field by using calculated field.
Field Data


Thanks for reaching out. Can you provide more detail on your example, please?


in a calculated field you would just reference {job_status}

This would be an example.

ifelse({job_status}=‘success’, 1,0)

For filtering you would add a filter that looks at this job_status field.