Issue in calculating the sum of customers account

[Ehab1996]

I have two data tables: the first is the customers table, which contains 5,000 records, and the second is the accounts table, which contains 9,600 records. I linked the two tables using the customer code When I try to find out the number of customers who have accounts, the result shows zero, even though I used this function count(distinct(if(Account_ID,Customer_ID))) Can you help me with that?

[Rohan]

Hi @Ehab1996 ,

Instead create a flag field in the accounts table  & use this :

Count(distinct {<Flag={"Y"}>} Customer_Code)

The If() that you have written is not correct. that's why it's getting evaluated as null & the count is showing 0.

Regards,

Rohan.

[Anil_Babu_Samineni]

The condition not fulfilled, perhaps this?

count(distinct if(Account_ID=Customer_ID, 1))

[Ehab1996]

I don't think so, because before I used to do this condition and get the correct result