Share
ReportI set up a report per management request to include the # of workdays in the month and # of weekend/holidays in the month on the report. I used one Excel worksheet to put in the data and used a combined worksheet link column to bring this info in to the Report Designer row format. The numbers pulled in correctly for the multiple individual units of the tree, HOWEVER, the groups of units are rolling up to various summaries including the consolidated group and making it look like there are 400 days in a month because of all the individual units adding up in to summaries.
I already had this problem when I previously used a unit account to put in this info. I changed to hard-coding the number of days into the report by just typing in the days in the formulas column, such as +22 for the month of April since there are 22 workdays in April. Using this method, the 22 was on every unit and the consolidated group correctly showed the number 22.
Unfortunately, this is not a reasonable way to solve this problem since we have to go in every month and change the number and I also want a YTD total of days. I thought using the Excel report and only pulling from one worksheet and not multiple worksheets would accomplish the same result.
Does anyone know how to cause the report to bring in this number from the Excel file and force it to each summary unit instead of accumulating or rolling up the number of days? Surely we can't be the first company that tried to do this.
*This post is locked for comments
All responses (
Answers (
3