7 Replies Latest reply on Oct 2, 2018 5:26 PM by vikas.sharma.2

    Find best date which meets the threshold

    vikas.sharma.2

      Hi All,

       

      I am looking to find the best date which meets the threshold. Please find more details below

       

      In the below example, I have a parameter "Threshold" which is currently set for 80% and looking for the GR date by which I have enough qty to satisfy the threshold.

       

      Raw data -

      Expected Result -

       

      Any thoughts?

       

      I have attached sample workbook for review.

       

      Thanks

      VS