How to calculate working days in a month

building reports desktopintelligence
1

Hi All,

I have created a report in Deski 11.5. I’m trying to create a variable which calculates the number of working days per month?
Can somebody please help me.
Thanks in Advance.

shuchi (BOB member since 2007-09-24)

2

By far the easiest way to do this is with a calendar table in the database. If not, you’re going to have to determine which day the month starts on, and how many weeks have passed since that day, and then figure out how many weekends were included… it’s just messy. :slight_smile:

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Topic moved from “Building Reports” ==> BusinessObjects Classic sub-forum (which is for pre-XI versions of full-client Reporter) to the DesktopIntelligence (XI r2) sub-forum.

Anita Craig :us: (BOB member since 2002-06-17)

4

That’s without taking account of any national/bank holidays :wah:

A calendar table is definitely the way to go. So many uses, so versatile, so simple, so use one!

5

I agree get a calendar table.

Make sure you gather all the calendar requirements and local exceptions.

In Switzerland ever “State” has it’s own baknking holiday’s (some catolic some protestants) other are even more specific to towns or districts only.

In Retail a year has always 52 weeks. The week starts on a Friday. The month have 4,4,5,… weeks)

Not all years start on the 1st of January, …

Some customers have 16month or 5 quarters, …

The only logic about dates is that the logic can not be calculated with a formula

ClaireB :de: (BOB member since 2002-08-09)