Business Days calculation

[ddrake]

Also have one other issue which is driving me buggy :

Again, on CR9, SQL2K, Win2K server

Using Remedy, and trying to pull all cases (and total them) for a month, but only those that are on business days and average that number out (by only the number of business days). I've got a field in there that I've tried to use, called Business Day? and it's a Yes/No field. I can pull totals out no problem, but how do I come up with the number of days to divide into the total for the average?

Thanks!!

 

[IdoMillet]

Simply SUM the following Formula:
--------------------------------------
IF {Business_Day} THEN 1 ELSE 0
--------------------------------------

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

You can also create a Running Total field which does a count and in the evaluate use a formula use:
{table.Business day} = "yes".

-k

 

[ddrake]

Trying to format it as a cross-tab report, if possible, to match all the other reports we're producing for this client.