5 Replies Latest reply: Aug 18, 2011 7:59 AM by mrkachhia RSS

    Removing 0 Value Contents

       

      I have below table showing Invoice data.

       

      Invoice NO

      Invoice Date

      Part NO

      Qty

      Price

      Invoice Due Date

      PAID?

      5702021

      10/04/2011

      Part 001

      10

      € 10.00

      31/05/2011

      YES

      5702021

      10/04/2011

      Part 002

      5

      € 100.00

      31/05/2011

      YES

      5702023

      25/04/2011

      Part 003

      5

      € 80.00

      30/06/2011

      NO

      5702023

      25/04/2011

      Part 004

      10

      € 70.00

      30/06/2011

      NO

      5702025

      10/05/2011

      Part 005

      5

      € 30.00

      30/06/2011

      NO

      5702025

      10/05/2011

      Part 006

      15

      € 20.00

      30/06/2011

      NO

      5702025

      10/05/2011

      Part 007

      20

      € 25.00

      30/06/2011

      NO

      5702025

      10/05/2011

      Part 008

      25

      € 15.00

      30/06/2011

      NO

      5702029

      28/07/2011

      Part 009

      30

      € 10.00

      31/08/2011

      YES

      5702029

      28/07/2011

      Part 010

      30

      € 10.00

      31/08/2011

      YES

      5702030

      15/08/2011

      Part 011

      10

      € 10.00

      30/09/2011

      NO

      5702030

      15/08/2011

      Part 012

      10

      € 15.00

      30/09/2011

      NO

      5702030

      15/08/2011

      Part 013

      10

      € 20.00

      30/09/2011

      NO

       

      Based on this table, let me have code to get unpaid invoice data (shown below)

       

      UNPAID Invoice

      Invoice Date

      Invoice Due Date

      VALUE

      5702023

      25/04/2011

      30/06/2011

      € 1,100.00

      5702025

      10/05/2011

      30/06/2011

      € 1,325.00

      5702030

      15/08/2011

      30/09/2011

      € 450.00

      € 2,875.00