OTBI column formula assistance - Change 5 days to 5 working days

Question

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

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/26488/otbi-column-formula-assistance-change-5-days-to-5-working-days

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.

https://support.oracle.com/knowledge/Oracle%20Cloud/2742146_1.html

Hope this help.

Thank you.