>> 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])
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
