Skip to Content
0

How to show the difference between dates in Hours in Webi report

Apr 09, 2017 at 07:08 PM

84

avatar image

Hi,

I have report requirement like below, need to show difference between dates in hours.

Please help me out with variables logic to achieve the report requirement.

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

2 Answers

AMIT KUMAR
Apr 09, 2017 at 08:55 PM
0
Share
10 |10000 characters needed characters left characters exceeded
Shankar Choudary Apr 13, 2017 at 05:12 AM
0

Hi Amit,

Thanks for the logic..

We achieved the Variable logic to show hours between dates.

Can you provide the logic how to exclude Weekends from hours between dates.

Regards

Ravi Shankar

Show 1 Share
10 |10000 characters needed characters left characters exceeded

one think you can do to avoid the weekend is:

= [Variable] where (Not(DayName([Date] in ("Saturday";"Sunday")))

[Variable] is the same logic which Amit suggested.

0