Count based on other information

[Anonymous]

Hi All.

I am trying to count the number of customers if the condition is met, but I don't get the correct answer.

Ex.

Pol_no	info_no	customers
11223	12515	A
1233	11223	B
105053	105053	C

I used:

if(Pol_no = info_no),count(distinct customers))

What else can I try to give me the answer of 2?

[sunny_talwar]

Try this:

=Count({<customers = {"=Pol_no = info_no"}>}DISTINCT customers) or

=Count(DISTINCT If(Pol_no = info_no,  customers))

[Anonymous]

Because the condition has to be met, so only some of the customers should be counted

[sunny_talwar]

Attaching a sample to look at.

HTH

Best,

Sunny

[stigchel]

Have you tried my answer?

=Count({<Pol_no=P(info_no)>} customers)

[sunny_talwar]

I just did Piet‌ and it works like a charm

[Anonymous]

Thank you, it workes

[sunny_talwar]

No problem