HomeTroubleshooting@RISK for Excel: Simulation"No inputs found that affect this output" instead of Tornado Graph

4.41. "No inputs found that affect this output" instead of Tornado Graph

Applies to: @RISK 5.x–7.x

I run a simulation and everything seems fine. But when I look at Quick Reports, or when I do Browse Results and ask for a tornado, I see only this message:

No inputs found that affect this output.

Is your output actually varying, or does it have the same value in every iteration?

If your output is varying, but @RISK finds no inputs that influence it:

On the other hand, if your output isn't actually varying, then you need to take a look at the logic of your model. Maybe you started from a deterministic model, and you haven't yet changed the constants to @RISK inputs (probability distributions). Use Excel precedent tracing, on the Formulas tab, to find the precedents of your output.

Here's a good technique for testing your model when you're not getting the kind of variation you expect. Activate the Random/Static icon (the "rolling dice" icon), then press F9 repeatedly to have @RISK draw new random numbers for all distribution. If a cell isn't varying the way you think it should, look at that cell and its precedents to check the logic of your model.

See also:

Additional keywords: Can't get tornado graph

Last edited: 2018-03-29

This page was: Helpful | Not Helpful