OTBI column formula help - change days to working days — 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

OTBI column formula help - change days to working days

in Reporting and Analytics for HCM 1 comment

In my report I need the following column formula to calculate 5 working days (not 5 days as it does now) and leave out Saturdays and Sundays. Any help would be great.

CASE WHEN CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Termination Date", CAST("Assignment Event Details"."Assignment Last Update Date" AS DATE)) > 5 THEN 'Y' ELSE 'N' END = 'Y' THEN TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Termination Date", CAST("Assignment Event Details"."Assignment Last Update Date" AS DATE)) ELSE NULL END

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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