I don't know if there's another way to do it, but ...
# general
j
I don't know if there's another way to do it, but in your results, you can use a Formula (Text) column with the formula:
CASE WHEN {isinactive} = 'T' THEN 'Inactive' WHEN {releasedate} IS NOT NULL THEN 'Terminated' ELSE 'Active' END