Email Address Formula — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!