Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How to write below statement as SET ANALYSIS?
=if(COLUMN1<>'FINAL', if(COLUMN2<>'CREATED', SUM(QTY*Price)))
Regards,
Manish
Hi,
In set analysis -= is <>
SUM({<COLUMN1-={'FINAL'},COLUMN2-={'CREATED'}>} QTY*Price)
Celambarasan
NOT WORKING...!
Hi,
Can you tell me where you used this expression?
Celambarasan
Dear Celambarasan,
I have below table....
COLUMN1 FINAL and COLUMN2 blank means order sent to supplier
COLUMN2 CREATED means order CREATED but not sent to supplier
I need CUSTOMER WISE total where COLUMN 1 is not FINAL and COLUMN 2 is blank means order still need to be created.
COLUMN1 | COLUMN2 | Customer Name | PART NO | QTY | PRICE | TOTAL |
CREATED | CUSTOMER 01 | PART 001 | 68 | 6.21 | 422.28 | |
CUSTOMER 02 | PART 002 | 5 | 82.46 | 412.30 | ||
FINAL | CUSTOMER 02 | PART 003 | 5 | 82.46 | 412.30 | |
FINAL | CUSTOMER 02 | PART 004 | 3 | 209.10 | 627.30 | |
FINAL | CUSTOMER 03 | PART 005 | 40 | 1.47 | 58.80 | |
FINAL | CUSTOMER 03 | PART 006 | 100 | 3.87 | 387.00 | |
CREATED | CUSTOMER 03 | PART 007 | 20 | 4.60 | 92.00 | |
CUSTOMER 03 | PART 008 | 20 | 4.87 | 97.40 | ||
FINAL | CUSTOMER 03 | PART 009 | 50 | 5.21 | 260.50 | |
FINAL | CUSTOMER 03 | PART 010 | 150 | 4.57 | 685.50 | |
CUSTOMER 04 | PART 011 | 200 | 49.50 | 9900.00 | ||
CUSTOMER 04 | PART 012 | 306 | 49.50 | 15147.00 | ||
CUSTOMER 04 | PART 013 | 50 | 40.84 | 2042.00 | ||
CUSTOMER 05 | PART 014 | 20 | 13.54 | 270.80 | ||
FINAL | CUSTOMER 05 | PART 015 | 10 | 28.09 | 280.90 | |
CUSTOMER 05 | PART 016 | 40 | 3.17 | 126.80 | ||
FINAL | CUSTOMER 05 | PART 017 | 25 | 4.30 | 107.50 | |
FINAL | CUSTOMER 05 | PART 018 | 20 | 5.55 | 111.00 | |
FINAL | CUSTOMER 06 | PART 019 | 1 | 2.07 | 2.07 | |
FINAL | CUSTOMER 06 | PART 020 | 1 | 188.86 | 188.86 | |
CREATED | CUSTOMER 06 | PART 021 | 5 | 127.24 | 636.20 | |
CREATED | CUSTOMER 06 | PART 022 | 5 | 127.95 | 639.75 | |
CUSTOMER 06 | PART 023 | 2 | 76.34 | 152.68 | ||
FINAL | CUSTOMER 06 | PART 024 | 1 | 74.46 | 74.46 |
Hi,
Check with this
SUM({<COLUMN1-={'*'},COLUMN2-={'*'}>} QTY*Price)
or
SUM({<COLUMN1={''},COLUMN2={''}>} QTY*Price)
Celambarasan
Hi,
While loading data in script replace Column2 with empty values as N/A or any other values.
LOAD
column1,
If(Len(Trim(column2)) > 0, Column2, 'N/A') AS column2
FROM DataSource;
Now use this epxression
SUM({<column1-={'FINAL'},column2={'N/A'}>} QTY*Price)
Hope this helps you.
Regards,
Jagan.