Forum Discussion

ht2567306's avatar
ht2567306
Icon for Helper I rankHelper I
6 years ago

How to delete the two rows that are offset each other

Hi all,

 

I have a sales table and one column is called "shipment quantity", some quantities are negative and I want to delte them, but the harder part is that I also want to delete the associated positive one. 

 
For example, I surely want to delete line 3, but I also need to delete line 2. Line 2 and line 3 are exactly the same except for shipment quantity.

 

Thank you in advance,

7 Replies

  • ht2567306's avatar
    ht2567306
    Icon for Helper I rankHelper I
    6 years ago

    what happened in reality is that some shipments are shipped and bounced back. hope this helps,

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI ht2567306 

       

      measure = Calculate(sum(table[col]), allexcept(table,table[column]))

      And filter to exclude zero.

      • ht2567306's avatar
        ht2567306
        Icon for Helper I rankHelper I
        6 years ago

        Anonymous hey,

        would you mind explaning a bit about 

        measure = Calculate(sum(table[col]), allexcept(table,table[column]))

        I dont think this will do the trick.

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI ht2567306 

     

    I would rather sum them up and get 0. and filter to exclude 0.

    • ht2567306's avatar
      ht2567306
      Icon for Helper I rankHelper I
      6 years ago

      Hi man,

       

      How do you sum it up?

      I have many rows, most of them are normal ones with shipment quantity a positive number.

       

      How do you only sum up those 2 that are problematic.