6 Replies Latest reply: Mar 30, 2012 8:06 AM by Alwin Scheerens RSS

    Create total column dynamically depending on existing of files

    Alwin Scheerens

      Hi all,

       

      I need some help with tables:
      In my script I refer to a folder on a network with XLSX files
      always of the same type: 79706 01.xlsx or 78354 01.xlsx or 79706 02.xlsx

      Where 79706 and 78354 is the unique officeID
      and 01, 02 stands for the month.
      At the end of beginning of April we create a new file “79706 03.xlsx”

      Now in my table I want a column for each month

      ID

      January

      February

      March

      Total

      79706

      12

      8

      0

      20

      78354

      5

      13

      0

      18

       

      At this time my total = January + February
      next month it should be total = January + February + march
      If I say at this time total = January + February + march à you get stupid values, because the file does not exist.
      I want to create total once and it should update dynamically.

      Please I need some help with this?

       

      regards,

      Alwin