2 Replies Latest reply: Apr 17, 2014 9:41 AM by Rupert Cavendish RSS

    Slider Variables with Varies a Compound Calculation

      Hi all

       

      I have a scenario analysis tab in my QV tab which allows the user to vary the Return on Investment (ROI) however I don't know how to recalculate the compounding return based on a slider value.

       

      For Example....

       

      If user sets the ROI slider to 5% then a return of £100 is

      Yr 1 = 100 * 105% = £105

      Yr 2 = 105 * 105% = £110.25

       

      Or the user could put the slider to a value of 10% so

      Yr 1 = 100 * 110% = £110

      Yr 2 = 110 * 110% = £121

       

      The key to the problem is how can I take the output from Yr 1 and put it as the input for Yr 2?

       

      Let me know if the above isn't clear.

       

      Thanks