Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this:
=Count({<customers = {"=Pol_no = info_no"}>}DISTINCT customers)
In your above example, the answer should be 1, right? Only for the last row Pol_no = Info_no?
if( Pol_no = info_no ,customers)
if 'Customers' column contains the 'number of customers' then y do u want count again?
Or =Count(DISTINCT If(Pol_no = info_no, customers))
if you want to count on front end then use Set expression as sunindia 's
Hi,
maybe you want to have 1 for total result.
Regards.
Try with
=Count({<Pol_no=P(info_no)>} customers)
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
You have a typo in your sample