I am trying to create a calculation in Cognos based on a number of Criteria. For example, I want to get a count of all of the records in my data set that have the following criteria:
Data_Level = "Aggregate"
Problem_Area = "Request"
IsResearch = "No"
Substate_ID = "Incomplete - Cancelled"
I want to then call this value: 'Aggregated Data - Non Research'
Thanks in advance for your feedback. I'm conducting a feasibility test of Cognos compared to other BI Tools so I am trying to replicate the same report across tools to gauge their usability. So far I am finding Cognos the most difficult to find resources on.
Regards, Jason
I would just create an if then else field which gives you a 1 if the conditions are met and 0 if they are not, then total that.
total(If ([Data_Level] = "Aggregate" and [Problem_Area] = "Request" and [IsResearch] = "No" and [Substate_ID] = "Incomplete - Cancelled") then (1) else (0))