Count question

[Anonymous]

Dear specialists

I need to count the amout of this the stoke of a product in database 1 is different then in database 2.

I got all the data right now like:

Product         LocationA         LocationB
0001                    1                         1

0002                    2                         1

0003                    2                         2

0004                    1                         3

0005                    0                         1

I need a calculation that counts the times that LocationA <> LocationB, in this case the outcome should be 3

Any suggestions?

Thanks.

[#2 · Accepted solution]

Hi,

Try     Sum(if(LocationA <> LocationB, 1, 0) )

[#3]

a.medina's method works.

Please see attached document. I also did this another way by loading  a new column name and just differentiating between the 2 conditions

Cheers,

Byron

[Anonymous]

Thanks and Thanks, that was what I needed.