on 11-16-2017 10:01 AM
Hello,
Could someone please guide me with the logic of excluding holidays from business working hours?
I have a requirement where I have to calculate the time spent between two dates excluding the weekend and the holidays. I have managed to remove the weekends but need a work around for removing the holiday time.
Thanks in advance.
You have to maintain calendar table in the data base with some holidays flag and then use this table in the universe and report to exclude holidays.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.