6 Replies Latest reply: Sep 16, 2013 9:14 AM by Antoine Frangieh RSS

    Autogenerate from Resident Table

    Byron Van Wyk

      Hi Guys and Gals,

       

      I'm having some trouble trying to figure this one out and would like some help achieving this output.

       

      I have a resident table with say 3 account fields, 3 account values and 3 account dates

       

      AccountField, AccountValue, AccountDate

      A, 100, 2010/10/01

      B, 200, 2010/10/01

      C, 300, 2010/10/01

       

      In the front end of the report there is 6 variables ( 2 by 3) that I want to apply an increase to the above AccountValue fields that the EU will decide.

      So variable 1 will be for account A and says apply increase in Mar {Mar being the actual value they have selected}, variable 2 will say select the amount that the variable must increase by, EU select 5% {5% the value the accountvalue will increase by}

       

      I want to autogenerate based on this above information a table of values taking into account these input fields. The last condition is that this information is annual and that the % increase will always be applied to the last value in the month before it applies. Below is an output example of account A

       

      AccountField, AccountValue, AccountDate

      A, 100, 2010/10/01

      A, 100, 2010/11/01

      A, 100, 2010/12/01

      A, 100, 2011/01/01

      A, 100, 2011/02/01

      A, 105, 2011/03/01

      A, 105, 2011/04/01

      .

      .

      .

      .

      .

      .

      A, 105, 2012/02/01

      A, 110.25,2012/03/01

       

      and so forth for the number of months i want to autogenerate for. I'm really hoping there is someone out there that has attempted this type of autogenerate off some preloaded information and applied inputs as illustrated above.

       

      Thanking all in advance

       

       

      Cheers,

      Byron