I created a report that reports data based on a date range for the last (0-30days (prompt)). I created a join for the primary view used in the report to another view that contains date infomation such as whether it's a weekend, work day, or holiday.
In the last 30 days at least I know that Thanksgiving occured. I would like for the report to know that there was 1 Holiday during this time period.
My counting attempts have failed so far. The join appears to be working because if I just make the calucation report Type then Holiday appears beside dates of 11/27/2003.
How do I create a caculations that will produce a result of 1? Which would be the number of Holidays in the past 30 days.
Thanks,
Mark
Consultants Club Corp.
In the last 30 days at least I know that Thanksgiving occured. I would like for the report to know that there was 1 Holiday during this time period.
My counting attempts have failed so far. The join appears to be working because if I just make the calucation report Type then Holiday appears beside dates of 11/27/2003.
How do I create a caculations that will produce a result of 1? Which would be the number of Holidays in the past 30 days.
Thanks,
Mark
Consultants Club Corp.
then (1) else (0)) appropriately grouped can produce the desired result.