Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI column formula assistance - Change 5 days to 5 working days
I am trying to amending the below column formula to count 5 working days instead of 5 days (which it is at the moment)? I need to exclude Saturdays and Sundays. Can anyone help please?
CASE WHEN CASE WHEN TIMESTAMPDIFF(SQL_TSI_DAY, "Worker"."Termination Notification 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 Notification Date", CAST("Assignment Event Details"."Assignment Last Update Date" AS DATE)) ELSE NULL END
Thank you
Answers
-
Hi @Tracy Goodchild,
Welcome to the Oracle Analytics Community!
Please take a look into the following Oracle note which might be useful for the initial understanding and a good starting point to change your existing formula.
Hope this help.
Thank you.
0
