Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 09, 2017 at 08:55 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2017 at 05:12 AM

    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

    Add comment
    10|10000 characters needed 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.