Changing a variable in a data set

%3CLINGO-SUB%20id%3D%22lingo-sub-2786863%22%20slang%3D%22en-US%22%3EChanging%20a%20variable%20in%20a%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2786863%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20data%20set%20where%20the%20output%20changes%20depending%20on%20what%20stock%20price%20i%20use%20in%20one%20of%20the%20variables.%20I'd%20like%20to%20see%20the%20output%20across%20many%20price%20points.%20So%20if%20i%20enter%2010%20in%20the%20price%20point%2C%20what's%20the%20answer%2C%2011%2C%2012%2C%2013%2C%20etc.%20I'd%20like%20to%20make%20a%20list%20of%2010%20thru%2050%20and%20have%20it%20show%20me%20what%20the%20outcome%20would%20be%20at%20each%20point%20without%20recreating%20the%20data%20column%2040%20times.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2786863%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2786918%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20a%20variable%20in%20a%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2786918%22%20slang%3D%22en-US%22%3EMaybe%20Data%20Tables%20could%20help.%20They%20are%20useful%20if%20you%20want%20to%20run%20multiple%20different%20inputs%20through%20a%20set%20of%20calculations%20and%20capture%20multiple%20single%20value%20output.%3CBR%20%2F%3E%3CBR%20%2F%3EHere%E2%80%99s%20a%20white%20paper%20I%20wrote%20on%20Data%20Tables%20a%20very%20long%20time%20ago%20%3CA%20href%3D%22https%3A%2F%2Faccessanalytic.com.au%2Fwp-content%2Fuploads%2Fwhite-papers%2F7.pdf%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faccessanalytic.com.au%2Fwp-content%2Fuploads%2Fwhite-papers%2F7.pdf%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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