2 Replies Latest reply: Jul 11, 2012 7:02 AM by Siva Boggarapu RSS

    How to write set analysis

    Siva Boggarapu

      Hi Everyone,

       

      Can anyone help me how to write set analysis for this below three expression?

       

      1)RangeMin($(vMarketFare1),$(vMarketFare2),$(vMarketFare3),$(vMarketFare4),$(vMarketFare5),$(vMarketFare6),$(vMarketFare7),$(vMarketFare8),

      $(vMarketFare9),$(vMarketFare10),$(vMarketFare11),$(vMarketFare12),$(vMarketFare13),$(vMarketFare14),$(vMarketFare15),$(vMarketFare16),

      $(vMarketFare17),$(vMarketFare18),$(vMarketFare19),$(vMarketFare20))

       

       

      2)RangeMin(If($(vMKTFare1) = $(vMarketFare2), Null(), $(vMarketFare2)), If($(vMKTFare1) = $(vMarketFare3), Null(), $(vMarketFare3)), If($(vMKTFare1) = $(vMarketFare4), Null(), $(vMarketFare4)), If($(vMKTFare1) = $(vMarketFare5), Null(), $(vMarketFare5)),If($(vMKTFare1) = $(vMarketFare6), Null(), $(vMarketFare6)),

      If($(vMKTFare1) = $(vMarketFare7), Null(), $(vMarketFare7)),If($(vMKTFare1) = $(vMarketFare8), Null(), $(vMarketFare8)),If($(vMKTFare1) = $(vMarketFare9), Null(), $(vMarketFare9)),

      If($(vMKTFare1) = $(vMarketFare10), Null(), $(vMarketFare10)),If($(vMKTFare1) = $(vMarketFare11), Null(), $(vMarketFare11)),If($(vMKTFare1) = $(vMarketFare12), Null(), $(vMarketFare12)),

      If($(vMKTFare1) = $(vMarketFare13), Null(), $(vMarketFare13)),If($(vMKTFare1) = $(vMarketFare14), Null(), $(vMarketFare14)),If($(vMKTFare1) = $(vMarketFare15), Null(), $(vMarketFare15)),

      If($(vMKTFare1) = $(vMarketFare16), Null(), $(vMarketFare16)),If($(vMKTFare1) = $(vMarketFare17), Null(), $(vMarketFare17)),If($(vMKTFare1) = $(vMarketFare18), Null(), $(vMarketFare18)),

      If($(vMKTFare1) = $(vMarketFare19), Null(), $(vMarketFare19)),If($(vMKTFare1) = $(vMarketFare20), Null(), $(vMarketFare20)))

       

      3)RangeMin(

                If($(vMarketFare1) = MKT1 OR $(vMarketFare1) = MKT2, Null(), $(vMarketFare1)),

                If($(vMarketFare2) = MKT1 OR $(vMarketFare2) = MKT2, Null(), $(vMarketFare2)),

                If($(vMarketFare3) = MKT1 OR $(vMarketFare3) = MKT2, Null(), $(vMarketFare3)),

                If($(vMarketFare4)=  MKT1 OR $(vMarketFare4) = MKT2, Null(), $(vMarketFare4)),

                If($(vMarketFare5) = MKT1 OR $(vMarketFare5) = MKT2, Null(), $(vMarketFare5)),

               If($(vMarketFare6) = MKT1 OR $(vMarketFare6)= MKT2, Null(), $(vMarketFare6)),

                                 If($(vMarketFare7) = MKT1 OR $(vMarketFare7)= MKT2, Null(), $(vMarketFare7)),

                                 If($(vMarketFare8) = MKT1 OR $(vMarketFare8)= MKT2, Null(), $(vMarketFare8)),

                                 If($(vMarketFare9) = MKT1 OR $(vMarketFare9)= MKT2, Null(), $(vMarketFare9)),

                                 If($(vMarketFare10) = MKT1 OR $(vMarketFare10)= MKT2, Null(), $(vMarketFare10)),

                            If($(vMarketFare11) = MKT1 OR $(vMarketFare11)= MKT2, Null(), $(vMarketFare11)),

                            If($(vMarketFare12) = MKT1 OR $(vMarketFare12)= MKT2, Null(), $(vMarketFare12)),

                            If($(vMarketFare13)=MKT1 OR $(vMarketFare13)= MKT2, Null(), $(vMarketFare13)),

                            If($(vMarketFare14) = MKT1 OR $(vMarketFare14)= MKT2, Null(), $(vMarketFare14)),

                            If($(vMarketFare15) = MKT1 OR $(vMarketFare15)= MKT2, Null(), $(vMarketFare15)),

                            If($(vMarketFare16) = MKT1 OR $(vMarketFare16)= MKT2, Null(), $(vMarketFare16)),

                            If($(vMarketFare17) = MKT1 OR $(vMarketFare17)= MKT2, Null(), $(vMarketFare17)),

                            If($(vMarketFare18) = MKT1 OR $(vMarketFare18)= MKT2, Null(), $(vMarketFare18)),

                            If($(vMarketFare19) = MKT1 OR $(vMarketFare19)= MKT2, Null(), $(vMarketFare19)),

                            If($(vMarketFare20) = MKT1 OR $(vMarketFare20)= MKT2, Null(), $(vMarketFare20))

                )

       

      Thanks,

      Siva