Hi,
I'm creating a report that is calculating the number of applicants that were processed within a certain number of days. The numeric value of the workday is already stored on a table. But the only way I figure out how to do this in Cognos was to add singletons with filters such as [Completion_Workday_NUM]-[Application_Workday_NUM]=2 (meaning it took two days to process). I have columns with the counts for each of these numbers (2 Days, 3 Days ... 11+ Days). A list would not work due to the different filters for the same item and a crosstab did not seem appropriate so I used singletons. That part of the report works.
However, I need a second row that shows what percentage were processed in x number of days. It should be the count from the each column divided by the total. I cannot figure out how to reference each total without causing it to get a cross join error.
This should be a simple report, but I cannot figure out how to do it in Cognos.
I'm creating a report that is calculating the number of applicants that were processed within a certain number of days. The numeric value of the workday is already stored on a table. But the only way I figure out how to do this in Cognos was to add singletons with filters such as [Completion_Workday_NUM]-[Application_Workday_NUM]=2 (meaning it took two days to process). I have columns with the counts for each of these numbers (2 Days, 3 Days ... 11+ Days). A list would not work due to the different filters for the same item and a crosstab did not seem appropriate so I used singletons. That part of the report works.
However, I need a second row that shows what percentage were processed in x number of days. It should be the count from the each column divided by the total. I cannot figure out how to reference each total without causing it to get a cross join error.
This should be a simple report, but I cannot figure out how to do it in Cognos.