Web Intelligence Problem - Something Like CountIF

[former_member1012301]

I currently have a Dimension of numbers [On Target?], which are 0 or 1 depending on if another condition is true, that match up to a longer list of records. It's shows 'did this take more than 24 hours?' and displays correctly on that list of records.

I want to summarize this in another report, filtering by personnel, which is a preexisting dimension. If this were Excel, I'd say =COUNTIF( {list of records} , {column within list of records} = condition ). In this case I thought a Measure defined as [# On Target] = Sum( [On Target?] ) would be great. I thought it would have the capability to be filtered by personnel, and sum the 0s or 1s to a whole number within the amount of records that match that personnel. Not a big deal. However, this doesn't work. For any personnel, the total is either 0 or 1, making me think the Sum isn't good enough to aggregate in this case. I want to know either A) how to fix what I did or B) what I might be missing to get this to work properly.

[jerryjanda]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.
Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.
First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.
I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.
One last thing: If you're interested in connecting with community members, please pay a visit to our new Welcome Corner. You'll need to sign up, but it's a great way to interact with peers and get to know other experts!
I hope you find this advice useful, and we're happy to have you as part of SAP Community!
All the best,
--Jerry