5 Replies Latest reply: Jun 16, 2016 5:11 AM by Marcus Sommer RSS

    How to get dynamic value for diff dates while creating a row by using two rows in script

    Jyoti Ranjan

      Hi,

      I have two Tables.One is Balance And Another Is Liabilities.

      I have to peek last row of both the table and subtract them and create a new row.this row will added last after concatenating both the tables.Everything is working for single date but for multiple date it is giving same values.

       

      so how can i make it dynamic for dates.

      here are my codes.plz help me.

       

      Below the Balance Table

      let vYactual= PEEK('YActual');

      let vMactual= PEEK('MActual');

      let vBudget= PEEK('Budget');

       

      Below the Liabilities Table

      let vLYactual= PEEK('YActual');

      let vLMactual= PEEK('MActual');

      let vLBudget= PEEK('Budget');

       

       

       

       

      After concatenating both Balance and Liabilities Table

      below the resulting table

      let vYActual=$(vYactual)-$(vLYactual);

      let vMActual=$(vMactual)-$(vLMactual);

      let vBActual=$(vBudget)-$(vLBudget);

      Load

      $(vYActual) as YActual,

      $(vMActual) as MActual,

      $(vBActual) as Budget,

      'NET ASSETS' AS GLType,

      'TOTAL NET ASSETS' AS Name,

      ReportDate

      Resident Balance;

       

       

      Note:All table have same column name.