Forum Discussion
Changing a variable in a data set
I have a data set where the output changes depending on what stock price i use in one of the variables. I'd like to see the output across many price points. So if i enter 10 in the price point, what's the answer, 11, 12, 13, etc. I'd like to make a list of 10 thru 50 and have it show me what the outcome would be at each point without recreating the data column 40 times. Any ideas?
1 Reply
- Maybe Data Tables could help. They are useful if you want to run multiple different inputs through a set of calculations and capture multiple single value output.
Here’s a white paper I wrote on Data Tables a very long time ago https://accessanalytic.com.au/wp-content/uploads/white-papers/7.pdf
