Help in Expression

[#1]

Hi All,

I  need  count of accounts with below conditions  in single expression .

1.For Abc Name:

If same account is covered in 2  Abc names then count is 2 . The count will be taken from  unique group by Meeting ID

2.other than  Abc Name

If  the same account is covered in 2 names other than  Abc names then count is 1 . The count will be taken from  unique group by Meeting ID

Note:Names with  prefixed with Abc called Abc Names

Meeting ID	Meeting Name	Name	Account ID
M01	MMM	Abc  phase1	A001
M02	AAA	Abc phase2	A002
M03	DDD	Abc Phase 3	A001
M05	EEE	Abc phase 4	A003
M06	FFF	Anoro	A002
M07	HHH	Anoro1	A003
M08	JJJ	Relvar	A003
M09	FFF	Relvar1	A005

Thanks in advance

[Gysbert_Wassenaar]

Perhaps like this: Count(Distinct If(WildMatch(Name, 'Abc*'), Name, [Account ID]) )

[#3]

Hi ,

If the same account is covered in 2 names other than  Abc names then i should get count is 1 .

Currently count is coming for 2.

For  Abc names  count should be  2  if same account is covered in 2  Abc names .

The count will be taken from  unique group by Meeting ID