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

    Find best date which meets the threshold


      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.