Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating percentages from other rows

Status
Not open for further replies.

sbelli

Programmer
Dec 17, 2003
4
US
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.
 
Wanted to mention that thread401-1587394 sounds like it was doing something similar. But I don't think doing an 11-fold union is an option for the different time ranges.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top