15 Replies Latest reply on Aug 6, 2016 12:23 PM by Tom W

    Look up of a value. if it has then sum all the numbers

    Akhilesh Singh

      Hello All,

       

      I have attached an excel file. I want the below scenario.

       

      1) If Lifecycle for any product has "include" and shipment from demand.

       

      2) if Lifecycle for any product has both "include" and "exclude" then minus shipment from demand which having only include lifecycle.

       

      3) If lifecycle is exclude then there will be 0.

       

      Please help me to get this done.

       

      Thanks in advance.