3 Replies Latest reply: Nov 29, 2011 10:54 AM by Mark Rumpunen RSS

    Counting net value

      Below is a data of three companys (ID), which all have random number of transactions (rows).

       

      Now I would like to have a net value for each company - if one or more rows for that company equals 1, the net value for that company would be 1. If all the rows for the company are 0, the net value would be 0.

       

      ID    Data

      1     1

      1     0

      1     1

      1     0

      2     0

      2     0

      2     0

      3     0

      3     1

      3     1

       

      Int this case the net values for companies would be

      ID     Net value

      1     1

      2     0

      3     1

       

      How can I count that net value? There must be a simple solution, just can't figure it out...