16 Replies Latest reply: Nov 30, 2011 6:49 PM by javierortiz RSS

    How can I get nested IF´s and minimum value

      Hi, everybody, I have this Expression problem:

       

      I need that

       

      if VENTAS is less than 50% then my ABC VENTA column is "AA"

      if VENTAS is greater than 50% my ABC VENTA Column is "A"

      if VENTAS is grater than 80% my ABC VENTA Column is "B"

      If VENTAS is greater than 95% my ABC VENTA Column is "C"

       

      I already made this condition, but the problem is that my customer is asking me that the first NO_PARTE allways must bee "AA" but if my first "NO_PARTE" is greater than 50% my ABC Column wont be "AA"

       

      I pasted an example of this and I attached the APP.

       

      Please I really need your help!

       

      Thanks!!

      Picture1.jpgPicture2.png