Calculate Difference between Two Dates and Eliminate Weekend in WEBI

[Former Member]

hi

I have below requirements which i want to find the differences in their time frame.

I do concatenation if Modified Time and Modified Date in to one Column Name (Modified Final)

Again I combine Create Date and Create Time in to column name (Create Final)

Recent Modified Time along with Modified Date.

Modified Time	Modified Date	Create Date	Create Time	Final Result
1/1/2010	10:01	1/1/2010	9:30	1/1/2010  1/1/2010 10:01
2/2/2010	12:00	1/1/2010	10:00	2/2/10  12:00
2/1/2010	10:01	2/1/2010	10:00	2/1/2010 10:01

I want to calculate Difference between this

=(Modified Date & Modified Time- Creation Date and Creation Time) and Eliminate Weekends in this range fields.

Final Result Should be

= (Modified Date and Time (days calculate weekdays)- Creation Date and Time(Weekends))

Thanks

ram

[Former Member · Accepted solution]

Do you have time dimension in your universe?

[Former Member · Accepted solution]

Avinash,

Thanks for your reply.

Time dimension are not separate, its is a part of Modified date and Creation date from SAP Source system.

[Former Member · Accepted solution]

This should work

=RelativeDate([object];Floor(DayNumberOfWeek([object])/6)*(8-DayNumberOfWeek([object])))

If your date falls on Saturday it would adjust itself to Monday..Sunday becomes Monday as well

[Former Member · Accepted solution]

Avinash,

Thanks for your mail.

If you don't mind kind give me how to hard code based on this column.

In your code can you mention this column name and please share me.

Modified Date and Modified Time and Creation Date and Creation Time

With 4 Dimension I want to Calculate the difference between Modified-Creation.

Thanks

ram

[Former Member · Accepted solution]

=RelativeDate([object];Floor(DayNumberOfWeek([object])/6)*(8-DayNumberOfWeek([object])))

should be

=RelativeDate([final date];Floor(DayNumberOfWeek([final date)/6)*(8-DayNumberOfWeek([final date)))

..Assuming you already have the datediff done between modified and created time

[Former Member · Accepted solution]

Avinash,

Thanks for your reply once again.

Even I don't know what is that datediff, kindly suggest me as well.

Thanks

ram

[Former Member · Accepted solution]

Do you have your final day object use that in he formula i mentioned above

[Former Member · Accepted solution]

I believe I can get Date Difference base based on Modified Date- Creation Date? I'm a right.