Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
I think the expression should be like
= sum({<[PAID?]={'NO'}>} Qty*Price)
with dimensions like stated by biteguebiessono.
Regards,
Stefan
€2875.00 is total unpaid inovice value...
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
I think the expression should be like
= sum({<[PAID?]={'NO'}>} Qty*Price)
with dimensions like stated by biteguebiessono.
Regards,
Stefan
oooh yeah, it's supposed to be PAID= 'NO'
Thansk. it's working..