BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Use Calendar Query to Count Business Days


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
sdchris
Forum Member
Forum Member



Joined: 17 May 2017

Posts: 3



PostPosted: Tue Dec 03, 2019 12:39 pm 
Post subject: Use Calendar Query to Count Business Days

Hi All,

I currently use a formula I found on one of the business object blogs that calculate business days excluding weekends. It has worked great with the caveat that Holidays are included in the count. Recently I discovered my company has a work day calendar in a separate query. It identifies work days, which is great. However, I'm not sure how to bring that count to my old query.

After I merge the two calendar dates, I'm not sure how to exclude the holiday dates/weekend days. I excluded holidays/weekends in the query filter and then created a running count variable in a separate table to validate. I'm not sure how to get that data point into my other table based upon the calendar date merge.

Any thoughts?

Cheers,
Chris
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0533 seconds using 18 queries. (SQL 0.0277 Parse 0.0008 Other 0.0248)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo