Removing 0 Value Contents

[#1]

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

[#2]

€2875.00 is total unpaid inovice value...

[#3]

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

[swuehl · Accepted solution]

I think the expression should be like

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

with dimensions like stated by biteguebiessono.

Regards,

Stefan

[#5]

oooh yeah, it's supposed to be PAID= 'NO'

[#6]

Thansk. it's working..