Problems with "=count(if(...))" function

[#1]

Hi All

I have a problem with an count if function. I use this formula

=count (if (DCN.Sum_Diff>0,DCN.Sum_Diff))

And the result is 6, but as you can see in the tabe below the result is suppose to be 4. The two articles in the top is both counting 2 and not 1. Anyone have the same experinces with that? And has a solution for that?

Article	DCN.Site	DCN.Diff.L	DCN.Diff.W	DCN.Diff.H	DCN.Sum_Diff
3918201	C690	1	1	0	2
5909002	C690	1	1	0	2
8260001	C690	1	1	0	2
36027033	C690	0	1	1	2

This formula is working fine for site C190 and C290 that has data in the same WMS system (called ANT). Data for site C690 is coming from SattStore. I do not know if that is a problem in this issue.

I have the same problem in this formula. The result is 5582 but should be 2950. Can you maybe also solve that?

=sum(if(DCU.SKU-DCN.SKU=0,if(RangeMax(DCU.Length,DCU.Width,DCU.Height)=RangeMax(DCN.Length,DCN.Width,DCN.Height)and RangeAvg(DCU.Length,DCU.Width,DCU.Height)=RangeAvg(DCN.Length,DCN.Width,DCN.Height) and RangeMin(DCU.Length,DCU.Width,DCU.Height)=RangeMin(DCN.Length,DCN.Width,DCN.Height) and DCU.Volume-DCN.Volume=0 and DCU.Weight-DCN.Weight=0,0,1)))

Hope for some help.

Best regards

Bjarne

[#2]

Hi Lukas

Your answer is the same as Sokkorn and that gives 6 not 4.

Hi Rohit

I think you mean DCN.Diff.L or DCN.Diff.H and not twice DCN.Diff.W. But it works

Hi GJ

That works also.

Thanks guys. I have the same problem in this formula. The result is 5582 but should be 2950. Can you maybe also solve that?

=sum(if(DCU.SKU-DCN.SKU=0,if(RangeMax(DCU.Length,DCU.Width,DCU.Height)=RangeMax(DCN.Length,DCN.Width,DCN.Height)and RangeAvg(DCU.Length,DCU.Width,DCU.Height)=RangeAvg(DCN.Length,DCN.Width,DCN.Height) and RangeMin(DCU.Length,DCU.Width,DCU.Height)=RangeMin(DCN.Length,DCN.Width,DCN.Height) and DCU.Volume-DCN.Volume=0 and DCU.Weight-DCN.Weight=0,0,1)))