If Count > 1 then make one column for 1 count zero

[wonka1234]

Hi,

How can I do this? the left 4 columns are my data.  and the expected result is the right column.

If CountDistinct_Country > 1  then [Result] = 0  for 1 of the Countries.

Hopefully that makes sense.

Country	Name	Utilization	CountDistinct_Country	Expected resut
US	Alex	0.83	2	0
US	Alex	0	2	0
US	Alex	0	2	0
US	Alex	0.83	2	0
UK	Alex	0	2	0
UK	Alex	0	2	0
UK	Alex	0.83	2	.83
UK	Alex	0	2	0
UK	Alex	0	2	0
UK	Alex	0.83	2	.83
UK	Alex	0	2	0
CAN	Louis	0.85	1	.85
CAN	Louis	0	1	0
CAN	Louis	0	1	0
CAN	Louis	0	1	0
CAN	Louis	0	1	0

[Luke_C]

Hi @wonka1234 

Help me understand the logic - why are rows 1 and 4 not .83?