Skip to Content
0

Add workdays using a calculated column in HANA Modeling

Oct 18, 2016 at 07:48 PM

56

avatar image
Former Member

I need to build a calculated column that adds a number of workdays to a date . I would like to add the workdays based off the US factory calendar which has the US Holiday calendar associated with it.

Using the adddays function while factoring in the days of the week to skip over weekends, does not allow me to account for holidays which are applied to the SAP factory calendar.

Has anyone come up with a way to add workdays, based on a specific factory calendar (US in this case), to an existing date in a calculated column of a HANA model? If so, would you please share.

Thank you in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers