3 Replies Latest reply on Apr 23, 2018 10:10 PM by kumar bharat

    Sum falls in set date

    Michael Mc Brayer

      Hi all,

       

      would like to seek your expertise on this calculation.

       

      sum of sales should automatically fall in ND dates if queue date and ND is matched, workbook attached for reference.

       

      ND

      April 1, 2018 = 5617

      April 2, 2018 = 0

      April 3, 2018 = 0

      April 4, 2018 = 0

      April 5, 2018 = 0

      April 6, 2018 = 0

      April 7, 2018 = 0

      April 8, 2018 = 0

      April 9, 2018 = 4318

      April 10, 2018 = 0

      April 11, 2018 = 0

      April 12, 2018 = 0

      April 13, 2018 = 0

      April 14, 2018 = 0

      April 15, 2018 = 0

      April 16, 2018 = 0

      April 17, 2018 = 0

      April 18, 2018 = 0

       

      Thanks in advance