COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: needhelp01 on 05 Dec 2018 06:01:04 PM

Title: Count function with multiple criteria
Post by: needhelp01 on 05 Dec 2018 06:01:04 PM
I am currently struggling with a financial report that calculates an average that is based off a store count data item. I currently have two slicers. One is to return data from a specific company and the other is to return data from stores open that have been open a specified time period (comp). The store count data expression is count (1 within set (children ([Comp]))). The data returned is initially correct but is currently being divided by the wrong store count. I want it to be divided by the store count that is in the comp base and also in the specified company. Thank you for your help in advance.