Adding workdays to date field

[Former Member]

Good afternoon Everyone,

I use BI4 2 Web Intelligence Client

I have searched internet (no just through google) to try and find solution to this, unsuccessfully.

There is plenty of topics on subject of calculating networking days, which are still properly confusing, however, unfortunately I cannot use any of that.

The challenge that I have is following:

I have Release date field that is pulled from Bex Query and I need to add to it another field that contains In House Production time in days (working days) in order to get Estimated Completion Date.

So it would look something like this:

Release Date + In House Production Time = Estimated Completion Date

11/9/2017 + 10 (Working Days) = 11/23/2017

Right now if I use RelativeDate I get ECD of 11/19/2017 (Which is inaccurate)

I tried to apply networking days logic to it, but then depending on IHPT I would have to add the missing amount of days to it, which then again requires to figure out if more weekends show up at the newly created ECD, and so on.

Please help, as use of Webi in my department is hanging on this.

[former_member182342]

Hi Miroslav,

Can you share some screeen shots so we will get better idea. Whats your input and expected output.

If you used the relativedate function it will give you result which you are expected.

= RelativeDate(CurrentDate();10)

It will give you 12/24/2017 if current date is 12/14/2017.

Please let me know details with screenshots.

Regards,

Anish