3 Replies Latest reply: Dec 5, 2013 10:53 AM by Srini VEERAVALLI RSS

    Filter positive and negative values before aggregation

    62f2bb82-0941-435e-b6ba-5955b09842dc

      Hi All,

       

      I have a "Main Column" with 10 individual rows of data in and two empty columns create in the business model.

       

      I want to split the positive values from the "Main Column" in to one of the empty columns and negative values in the other.

       

      FOR EXAMPLE:

       

      MAIN COLUMN "PRICES"          EMPTY POSITIVE          EMPTY NEGATIVE

       

      1000                                         1000                               -900

      -900                                             800                              -700

      800                                             600                              -500

      -700                                             400                              -300

      600                                             200                              -100

      -500                                       

      400                                            

      -300                                            

      200                                            

      -100                             

       

      Thanks