Applies to: @RISK for Excel 5.5.0 and Up

 

@RISK Simulation Shows "No Data Values" or Errors

If running your model shows "There are no data values to graph" in Browse Results or "Error" in every row of Simulation Data, it could be caused by one of several issues depending on your @RISK version and model logic.

1. Logic Errors

• If your model was created for @RISK 5.5 or later, errors usually indicate a logic problem in your model.

• Use Shoeprint Mode or Footprint Mode to identify where errors occur.

• Open the Simulation Data window (small xᵢ icon in the Results ribbon) and follow steps in “Some Iterations Show Error in Data Window. What Can I Do?”

2. Filters Causing "Filtered" Rows

• If Simulation Data shows "Filtered" on every row instead of errors, you likely have a filter defined that excludes all values.

• Check the Define Filters button in the @RISK ribbon. A colored background indicates an active filter.

• You can disable the filter or adjust its settings.

• Standard filters affect a single input/output, while Iteration filters remove iterations across all linked inputs/outputs.

 

Solution Options:

• If your model requires the old behavior, go to Simulation Settings → Sampling tab → Update Statistic Functions, and change from "at the end of each simulation" to "each iteration".

• For input distributions, use RiskTheoPercentile or RiskTheoMean instead of RiskPercentile or RiskMean for more reliable statistics.

Best Practices:

• Examine your model logic to ensure outputs don’t depend on statistics that aren’t available until the end of the simulation.

• Use filters carefully to avoid excluding all iterations.

• Prefer “Theo” functions for input statistics rather than relying on iteration-based functions.

 

Related Articles:

Some Iterations Show Error in Data Window. What Can I Do?

Statistics for an Input Distribution