Filtering out field data in separate from a particular field

Question & Answer
,
1

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

2

Hi,

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

Thanks,
Sean

3

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.

image
image327×692 23 KB