2 Replies Latest reply: May 16, 2013 7:50 AM by Raghav Kumar RSS

    Minimum function

    Raghav Kumar

      Hi all

      I am trying hard to figure out a way for this. Kindly help.

       

      I have the following table after doing some work on the base data.

       

       

      PlaceWarehouseSourceFreight1Freight2Sum (Freight1, Freight2)
      P1WH1S110010110
      P1WH1S220020220
      P1WH2S120010210
      P2WH2S130020320
      P2WH2S240010410

       

       

      I want to add one column "Classification", which would give

           "L1" if the Sum column for a given Place is the MINIMUM among the available options.

           "L2" if the Sum column for a given Place is the 2nd MINIMUM and so on.

      I have showed the example for 2 Places.

       

      Something like this.

      PlaceWarehouseSourceFreight1Freight2Sum (Freight1, Freight2)Classification
      P1WH1S110010110L1
      P1WH1S220020220L3
      P1WH2S120010210L2
      P2WH2S130020320L1
      P2WH2S240010410L2

       

      Thanks in advance.