1 Reply Latest reply on Dec 17, 2016 10:28 PM by Shinichiro Murakami

    what if scenario based on reference investment v revenue table

    Ian Barton

      Hi All,


      Ive seen the following article on how to create parameters and allow user input to crete what if analyses.

      The output appears linear. I.e If investment is increased by 5%, sales increase 5%.

      I was hoping the expand on this with the following. How would I create the functionality to refer to an investment v revenue table. i.e a non linear curve so for example if investment (Y) is increased by 5%, the revenue increases by X%. The x and y would be defined in a reference table. The attached image is  graphical representation of this table.