T
Tom Shields
This one is kinda tough. I am trying to nest data tables, and the inner one
is not getting re-calculated. Basically I need to consider 5-10 scenarios
for a given input value, and select the most optimal. This works great with
a data table that tries all possible scenarios, then I pick the max outcome.
The problem comes when I want to graph a set of input values and their
outcomes - this requires a second data table, which depends on the first.
When I recalculate, the inner table never gets run - it always selects the
same scenario, even though it is not the correct one. Can anyone help?!?
Thanks in advance.
Tom Shields
is not getting re-calculated. Basically I need to consider 5-10 scenarios
for a given input value, and select the most optimal. This works great with
a data table that tries all possible scenarios, then I pick the max outcome.
The problem comes when I want to graph a set of input values and their
outcomes - this requires a second data table, which depends on the first.
When I recalculate, the inner table never gets run - it always selects the
same scenario, even though it is not the correct one. Can anyone help?!?
Thanks in advance.
Tom Shields