Count business days in report footer

[silck]

Hello,

I need to have a count of business days for each month placed in the report footer. The report has a set beginning date and the user inputs the ending date, therefore the ending date changes everyweek. I have gotten it to work great for the current month. I have also found a way to do the previous months, but since it is based on the ending date the user inputs, the formula only works if the ending date was always the same month in which this is not the case.
ex. 1
April Month report
Jan Feb Mar Apr
Bus days 21 22 20 21
ex. 2
May Month report
Jan Feb Mar Apr May
Bus days 21 22 20 21 22

I would greatly appreciate any help!

-Kim

 

[synapsevampire]

Not knowing how you addressed this for months, I'd suggest a cross tab to accomplish this:

Create a formula to provide a sum of biz days:

// Formula @BizDayCount
if dayofweek({MyTable.MyDateField}) in [2,3,4,5,6] then
1
else
0

Use the date field grouped by month into the Columns area (use group options, and select A column will be printed "for each month&quot.

Place the @BizDayCount formula in the summarized fields.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com