Set analysis with exclude condition

[bhavvibudagam]

Hi Experts,

Can anyone please help me on below set analysis expression.

=Count({<[RAG]={'R'},{Metric Group}={'Entertainment'},[Metric]-={" '-' "},Group-={" ' '  -"},[Sub Group] -= {" ' - ' "}>}[RAG ind])

Thanks in advance.

[jonathandienst]

>> Already from Metric Group I have Included {'Entertainment'} also from the same field need to exclude the null [Metric Group]-={"'-'"}.

Selecting Entertainment will automatically exclude the nulls.

>>=Count({<[RAG]={'R'},{Metric Group}={'Entertainment'},[Metric Group]-={"'-'"},[Metric]-={" '-' "},Group-={" ' '  -"},[Sub Group] -= {" ' - ' "}>}[RAG ind])

The second reference to the Metric Group will override the first and you have curly braces in the wrong position. To exclude null values, use

Count({<RAG = {'R'}, [Metric Group] = {'Entertainment'}, Metric = {'*'}, Group = {'*'}, [Sub Group] = {'*'}>} [RAG ind])