6 Replies Latest reply: Apr 3, 2012 8:24 PM by Marcos Herrera RSS

    Accummulated Null Problem

      Dear Community

       

      I have a script with the function code that builds good peek account, company, location, year and month, but I have a problem when the value is null in a month. An Example

       

      Account,Company,Location,Year,Month,Value,Value_Acum

      1010,A,A1,2010,1,100,100

      1010,A,A1,2010,2,200,300

      1010,A,A1,2010,3,300,600

      1010,A,A1,2010,4,400,1000

      1010,A,A1,2010,5,500,1500

      1010,A,A1,2010,6,600,2100

      1020,A,A1,2010,1,100,100

      1020,A,A1,2010,2,200,300

      1020,A,A1,2010,3,300,600

      1020,A,A1,2010,4,400,1000

      1020,A,A1,2010,5,500,1500

      1020,A,A1,2010,6,600,2100

      1020,A,A1,2010,7,700,2800

      1020,A,A1,2010,8,800,3600

      1020,A,A1,2010,9,900,4500

      1020,A,A1,2010,10,1000,5500

      1020,A,A1,2010,11,1100,6600

      1020,A,A1,2010,12,1200,7800

       

      If I want know the Value_Acum per year 2012, month 12, account 1010 there aren't. This is my problem. i need know how complete the missing months.

       

      example:

       

       

      1010,A,A1,2010,7,0,2100

      1010,A,A1,2010,8,0,2100

      1010,A,A1,2010,9,0,2100

      1010,A,A1,2010,10,0,2100

      1010,A,A1,2010,11,0,2100

      1010,A,A1,2010,12,0,2100