add business days

[system]

Try reading through these topics:

120×120 10.4 KB

Hello I have a calculation as a measure to work out the mean time for product orders and product invoices. I am using a derived table where the start and end dates for each month are retained. However, we only work Monday to Friday and I need to exclude weekends and bank holidays. At present the mean time is high and not reflected correctly. I am using BOB version 2003. I am new to sql so any assistance you can provide would be greatly appreciated. Code of measure is as follows: NULLIF ( …

120×120 10.4 KB

Hi, I’m new to Universe Design. I’m using a SQL DW as the datasource. My issue is that I want to calculate the working days between two dates. There is a working day calendar in the datawarehouse that uses 1’s to indicate working days for a particular country. There are different statuses that a book order can be in at any one time. I want to be able to choose two different statuses i.e. packed and shipping and view the number of working days based on the dispatch country. There are 20 pos…

120×120 10.4 KB

How can I calculate business days between two dates ? Developer_Designer (BOB member since 2009-08-09)

120×120 10.4 KB

Hi, Do we have any function that excludes (saturday and sunday) between two dates. In excel we use networkdays() function to derive the result. What function we have to use for above scenario in WEBI? Thanks Sriraman srijackson (BOB member since 2009-07-29)

HTH

NMG

---

mcnelson (BOB member since 2008-10-09)