Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've having trouble getting a count or sum with set analysis where there is multiple criteria. Here's what I have so far that isn't working.
=Count({$< [Next Qtr Flag] = {'1'} + [Next2 Qtr Flag]= {'1'} + [Next3 Qtr Flag] = {'1'},[ Probability ]={"*"}-{0}>}[Opp Unique ID])
I need to count or sum the [Opp Unique ID] for when the [Probability] is NOT equal to 0 for each 'QTR' flag. A very unsophisticated script would be as follows:
=Count({$< [Current Qtr Flag] = {'1'}, Probability ={"*"}-{0}>}[Opp Unique ID])+
Count({$< [Next Qtr Flag] = {'1'}, Probability ={"*"}-{0}>}[Opp Unique ID]) +
Count({$< [Next2 Qtr Flag] = {'1'}, Probability ={"*"}-{0}>}[Opp Unique ID]) +
Count({$< [Next3 Qtr Flag] = {'1'}, Probability ={"*"}-{0}>}[Opp Unique ID])
I appreciate any help.
Thanks!
All - I absolutely butchered this post in several ways. I had a very inaccurate title and possibly worse text, and you still walked me through it in spite of myself. I can't begin to thank you for not throwing me in front of a bus too badly for my own stupidity.
Message was edited by: Dan Mercer
I guess there are records that outside your count criteria .Hence the null values. and yes you can suppress those values by checking the Suppress When Value is null option in the Dimension tab.
Also check and test output so to be sure.
Your sum if works beautifully. Thanks so much! I only flagged Michael's as correct because his used set analysis, which was what I was originally trying to do.
no worries mate. Glad you found you solution.
Dan, feel free to change the "correct/helpful" marks, I'm not going to loose sleep over that