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

# 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
• ###### Removing 0 Value Contents

€2875.00 is total unpaid inovice value...

• ###### Removing 0 Value Contents

Hi,

Try to create a straight table with the following dimensions. 'Invoice NO', 'Invoice Date', 'Invoice Due Date'..... and include  the following expression:

sum({< PAID={"YES"}>} Price).

Regards

• ###### Removing 0 Value Contents

I think the expression should be like

= sum({<[PAID?]={'NO'}>} Qty*Price)

with dimensions like stated by biteguebiessono.

Regards,

Stefan