Duplicate Values from Join

[#1]

Hello,

I have this two tables that I joined but the values are duplicated. How can I divide the value 8.26 for every IMEI that occurs in the example?

Thank you.

[adamdavi3s]

I don't think they are duplicated, the data looks good to me.

In your test table you might just want to exclude where len(IMEI) <1

e.g. if(len(IMEI)<1,0,IMEI/Value)

[#3]

Hello Adam,

Thank you for your answer but the values are duplicated. For every IMEI the value should be 4.13(for this example).

[antoniotiman · Accepted solution]

Hi Doru,

try

Sum(Value)/Count(DISTINCT TOTAL <Product>  IMEI)

Regards,

Antonio

[#5]

Thank you Antonio