First Req. History Transaction date (when posted externallly)
MIN(CASE WHEN "Requisition Posting"."Posting Source" = 'Career Section - EXTERNAL' THEN EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER,"Requisition Tracking History"."Req. History Transaction Date",'mm-dd-yyyy') ELSE '' END)by "Requisition Identification"."Req. Identifier")
I used the formula above, it works when I pull Req. History Transaction date field to the report but I do not want to pull it to the report as it gives multiple records. When I don't, it shows as blanks. How can one report this?