cancel
Showing results for 
Search instead for 
Did you mean: 

Expectation is to get Time Taken in Net Work Days.Time Difference calculation Net Work Days

sachin1026
Discoverer
0 Kudos

In a story and attached screenshot these timerelated calculated measures need to show in terms of Net Work Days.

There is no standard function to achieve it. 

Example

DATEDIFF( [Date1], [Date 2], "day" )

Returns the number of days between Date1 and Date2 by calculating the difference: Date1 - Date2 = No. of days. This is overall days. What if this is required in Work Days that is excluding weekends.

View Entire Topic
AashishCherian
Advisor
Advisor
0 Kudos

Hi @sachin1026 ,

There is not standard function to do this. You can write a logic to exclude Sat and Sun. 
Check out this response on this community question https://community.sap.com/t5/technology-q-a/sap-analytics-cloud-count-only-the-business-days-in-date...

Hope this Helps.