4 Replies Latest reply: Feb 5, 2014 1:18 AM by Michael Gardner RSS

    Splitting of -ve and +ve values in 2 columns

      Hi All,

       

      How we can calculate -ve and +ve values in 2 columns.

       

      e.g.         A       B      C       

                     5       10      5         

                     5        3       -2

                   100       170     70

                     100       30     -70

                      201     501     300

      o/p          

                       A             D       E

                       5              5      -2

                     100           70     -70

                        201         300    -

       

      Thanks,

      Ravi