Help with Syntax for COUNT with two dimension requirements

[data_RN]

Hello All, 

I am hoping I have an easy one for you 🙂

I am trying to get the count for the number of programs with an advanced business case that is in a stage of either seed, alpha OR beta and I am having a hard time with the syntax.  I can get it to count using just one stage, but I cannot figure out how to include the others.

Here is what I have: 

Count({<[Program Name] = {"=[Business Case Model] = 'Advanced' and [Current Stage]= 'Seed'"}>} [Program Name])

I would like something like this:  

Count({<[Program Name] = {"=[Business Case Model] = 'Advanced' and [Current Stage]= 'Seed' OR [Current Stage]= 'Alpha' OR [Current Stage]= 'Beta'"}>} [Program Name])

I could also use the negative form: 

Count({<[Program Name] = {"=[Business Case Model] = 'Advanced' and [Current Stage]<> 'Initial' OR 'Pre-Seed'"}>} [Program Name])

Any help is appreciated...thanks!

[Anil_Babu_Samineni]

Perhaps this?

Count(If(([Business Case Model]='Advanced' and [Current Stage] = 'Seed') or ([Current Stage]='Alpha' or [Current Stage]='Beta'), [Program Name]))

[jonathandienst]

You may be over complicating the problem. Try this:

Count({<[Business Case Model] = {'Advanced'}, [Current Stage]= {'Seed', 'Alpha', 'Beta'}>} [Program Name])

[Anil_Babu_Samineni]

@jonathandienst  or I can think this way, As they are performing "Or" operator 🙂

Count({<[Business Case Model] = {'Advanced'}>+<[Current Stage]= {'Seed', 'Alpha', 'Beta'}>} [Program Name])

[jonathandienst · Accepted solution]

[Current Stage]= {'Seed', 'Alpha', 'Beta'}

is equivalent to Seed or Alpha  or Beta...

[data_RN]

This works!  I knew I was making it overly complicated.

Thank you for your quick reply!

Cheers!

[data_RN]

Thank you for this!  I needed a sum of meeting both criteria, but I need this very thing in a different section and will definitely add it to my notes.

Thanks again for your speedy response!