How to use a dashboard prompt in Case When query for a field

Summary:

Content (please ensure you mask any confidential information):

We have a custom field in OTBI report that uses Person Number as a prompt on a dashboard. Below is the analysis that shows Person Number is prompted:

The 'Status' field is a custom field that uses a CASE WHEN syntax. Below is the syntax:

CASE WHEN "Checklist Task Details"."Task Name" IN ('Criminal Check') AND "Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_CRIMINAL_CHECK_" = 'Validated'  
THEN 
	CASE WHEN "Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_CRIMINAL_CHECK_" = 'Validated' AND "Checklist Task Details"."Status" = 'Completed'    
	THEN 'Cleared'    
	ELSE 'Pending'    
	END 
WHEN "Checklist Task Details"."Status" = 'Completed' AND "Checklist Task Details"."Task Name" NOT IN ('Criminal Check') 
THEN 'Cleared' 
ELSE 'Pending' 
END