16 Replies Latest reply: Apr 25, 2017 8:12 AM by AC BC RSS

    Problems with sum

    Avishai Zonnenberg

      Hi

       

      i have a data set of production that i am doing some calculation and i need to show the sum by month

      here is the data sample:

               

      PRDDATEPRODPOOLITEMIDQTYSCHEDQTYGOODTIMENORMALIZATIONTIME/NORMALIZATION
      PRD0006735201/01/2017205D26-02GNPC-001223056
      PRD0006735601/01/2017205D26-02GNPC-001113056
      PRD0006849601/01/2017205CR3000000-01BTXH-0195951553
      PRD0007096502/01/2017205D26-04A1XH-001303060512
      PRD0007096801/01/2017205D26-04A1XF-001404060512
      PRD0007104102/01/2017325RP500-34BTN5-006200200150.6722.39
      PRD0007118301/01/2017205CR2000000-06G0NB-01551553
      PRD0007118502/01/2017325RP500-34BTN5-006200200150.6722.39
      PRD0007133802/01/2017205CR3000000-10R0XH-01441553
      PRD0007252402/01/2017205NR4020NS-02NTPR-0025050551
      PRD0007282901/01/2017100252-050002NR-FG200117505
      PRD0007320502/01/2017200242-2606PC-FF12036551
      PRD0007329901/01/2017205D26NS-06R2XH-0012260512
      PRD0007349401/01/2017205VB60-12N1XI-00411050

       

      when i try to get the sum of prodpool by month i cant seem to get it when i remove the PRD from the table

      DATE by MONTHPRODPOOLQTYSCHEDQTYSCHED*TIME/NORMALIZATION
      JAN 20172014,63027,089
      JAN 20173031,21549,977
      JAN 2017327,67148,764

       

      can someone help?