Applies to: @RISK 5.x and Up

Error:

No inputs found that affect this output.

Solutions:

1. If your output is varying, but @RISK finds no inputs that influence it:
   1. In Simulation Settings » Sampling, look at Collect Distribution Samples. 
      1. If it's set to None or Inputs Marked with Collect
         1. change it to All and rerun your simulation.
   2. If the output have precedents that include Excel volatile functions like RAND( ) and NOW( )
      1. It will vary but @RISK won't find any inputs because it considers only @RISK distributions to be inputs.
         1. Replace RAND( ) with RiskUniform(0,1), replace IF(RAND( )0.6,...) with IF(RiskBernoulli(1–0.6),...).
   3. If the simulation utilizes Microsoft Project and an MPP file
      1. Information about dependents moves between Project and Excel, and certain dependencies may not be recognized.
         1. In Simulation Settings » Sampling, change Smart Sensitivity Analysis to Disabled.
         2. If that's not sufficient, click @RISK's Project icon, then Project Settings, and change Simulation Engine to Standard.
2. If your output is constant
   1. Review your model logic. Use Excel’s precedent tracing (Formulas tab) to identify the precedents of your output.
   2. Test your model:
      1. Activate the Random/Static icon (the “rolling dice” icon), then press F9 repeatedly to have @RISK draw new random numbers for all distributions.
      2. If a cell isn’t varying as expected, check that cell and its precedents to verify your model logic.

Related Articles:

Results Not as Expected (Debugging Tips)

All Articles about Tornado Charts