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]

May be this:

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

[sunny_talwar]

In your above example, the answer should be 1, right? Only for the last row Pol_no = Info_no?

[Qrishna]

if( Pol_no = info_no ,customers)  

if 'Customers' column contains the 'number of customers' then y do u want count again?

[sunny_talwar]

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

[Qrishna]

if you want to count on front end then use Set expression as sunindia‌ 's

[Anonymous]

Hi,

maybe you want to have 1 for total result.

Regards.

[stigchel · Accepted solution]

Try with

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

[Anonymous]

Hi. No the answer should be 2. it shouldn't look at the order of the values, if the number is in col 1 and in col 2 it should be counted. thus the answer should be 2

11223 = 11223

105053= 105053

[sunny_talwar]

You have a typo in your sample