Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below table showing Invoice data against Customer ID.
Customer ID | Invoice No | Invoice Value | PAID? |
ABC | 11 | 125 | NO |
PQR | 12 | 130 | NO |
DEF | 13 | 140 | YES |
GHI | 14 | 155 | YES |
JKL | 15 | 146 | YES |
ABC | 16 | 128 | YES |
XYZ | 17 | 99 | NO |
MNO | 18 | 100 | NO |
PQR | 19 | 135 | NO |
XYZ | 20 | 198 | NO |
PQR | 21 | 197 | YES |
ABC | 22 | 210 | YES |
DEF | 23 | 150 | NO |
GHI | 24 | 95 | NO |
JKL | 25 | 50 | NO |
I want to get total value of unpaid invoices against each Customer ID.
Can someone please give me script?
The result should be as below
Customer ID | Invoice Value Not Paid |
ABC | 125 |
DEF | 150 |
GHI | 95 |
JKL | 50 |
MNO | 100 |
PQR | 265 |
XYZ | 297 |
TOTAL | 1082 |
Thaks in advance.
Hi,
use customer ID as dimension and as expression
=sum({<[PAID?]={'NO'}>} [Invoice Value])
assuming that Invoice Value, PAID? are your field names.
Stefan
Hi,
use customer ID as dimension and as expression
=sum({<[PAID?]={'NO'}>} [Invoice Value])
assuming that Invoice Value, PAID? are your field names.
Stefan
Thanks for your quick response. It's Working fine.