Email Address Formula

Hi Everyone,

I am building a report for one of our HR partners. She is using the report as a file loader to put employee data in an external employee recognition platform. She wants the report to only have EEs home emails on it, if they are in the system. If the employee doesn't have a home email in the system, she wants a blank for the email field.

I started by writing this Case When statement:

CASE WHEN "Workforce Management - Person Real Time"."Person Email Addresses"."Email Type" = 'Home Email' THEN "Workforce Management - Person Real Time"."Person Email Addresses"."Email Address" ELSE '' END