6 Replies Latest reply: Apr 28, 2012 7:38 AM by jagan mohan rao appala RSS

    SET ANALYSIS

      Hi

       

      How to write below statement as SET ANALYSIS?

       

      =if(COLUMN1<>'FINAL', if(COLUMN2<>'CREATED',  SUM(QTY*Price)))

       

      Regards,

      Manish

        • SET ANALYSIS
          Celambarasan Adhimulam

          Hi,

               In set analysis -= is <>

          SUM({<COLUMN1-={'FINAL'},COLUMN2-={'CREATED'}>} QTY*Price)

           

          Celambarasan

            • SET ANALYSIS

              NOT WORKING...!

                • SET ANALYSIS
                  Celambarasan Adhimulam

                  Hi,

                       Can you tell me where you used this expression?

                   

                  Celambarasan

                    • SET ANALYSIS

                      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.

                       

                      COLUMN1COLUMN2Customer NamePART NOQTYPRICETOTAL
                      CREATEDCUSTOMER 01PART 001686.21422.28
                      CUSTOMER 02PART 002582.46412.30
                      FINAL CUSTOMER 02PART 003582.46412.30
                      FINAL CUSTOMER 02PART 0043209.10627.30
                      FINAL CUSTOMER 03PART 005401.4758.80
                      FINAL CUSTOMER 03PART 0061003.87387.00
                      CREATEDCUSTOMER 03PART 007204.6092.00
                      CUSTOMER 03PART 008204.8797.40
                      FINAL CUSTOMER 03PART 009505.21260.50
                      FINAL CUSTOMER 03PART 0101504.57685.50
                      CUSTOMER 04PART 01120049.509900.00
                      CUSTOMER 04PART 01230649.5015147.00
                      CUSTOMER 04PART 0135040.842042.00
                      CUSTOMER 05PART 0142013.54270.80
                      FINAL CUSTOMER 05PART 0151028.09280.90
                      CUSTOMER 05PART 016403.17126.80
                      FINAL CUSTOMER 05PART 017254.30107.50
                      FINAL CUSTOMER 05PART 018205.55111.00
                      FINAL CUSTOMER 06PART 01912.072.07
                      FINAL CUSTOMER 06PART 0201188.86188.86
                      CREATEDCUSTOMER 06PART 0215127.24636.20
                      CREATEDCUSTOMER 06PART 0225127.95639.75
                      CUSTOMER 06PART 023276.34152.68
                      FINAL CUSTOMER 06PART 024174.4674.46
                        • SET ANALYSIS
                          Celambarasan Adhimulam

                          Hi,

                               Check with this

                              

                          SUM({<COLUMN1-={'*'},COLUMN2-={'*'}>} QTY*Price)

                          or

                          SUM({<COLUMN1={''},COLUMN2={''}>} QTY*Price)

                           

                          Celambarasan

                          • SET ANALYSIS
                            jagan mohan rao appala

                            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.