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

Errors

1. Found invalid formula ... Continue without Smart Sensitivity Analysis
2. The reference '...' in '...' has an OFFSET or INDIRECT, whose precedents cannot be traced.
   Continue without Smart Sensitivity Analysis

Background:

Smart Sensitivity Analysis was introduced in @RISK 5.0. It makes tornado charts and other sensitivity measures ignore inputs that are not actually precedents of the output.

As @RISK traces back from your @RISK outputs to your distribution functions, it may find an invalid Excel formula.

• "Invalid" doesn't necessarily mean the formula is invalid according to Excel's rules
• It could mean a valid formula that isn't supported by Smart Sensitivity Analysis

Solutions:

1. Click Yes and the simulation will proceed.
   1. Your simulation results will be correct.
   2. Tornado diagrams may show inputs that are not actually precedents of the output, if by chance they are significantly correlated with the output.
   3. If you want to avoid clicking Yes each time, see Solution 2.
2. Fix the Formula
   1. Go to the location given in the message
      1. Use F5 or Ctrl+F to search for the function mentioned.
      2. If the formula is actually invalid, fix it and re-run your simulation.
   2. NOTE: Smart Sensitivity Analysis cannot work with certain Excel functions, even in valid Excel formulas.
      1. Please see Precedent Checking for the list.
      2. If the message identifies one of the functions listed:
         1. Change the formula (if possible)
         2. Disable Smart Sensitivity Analysis on the Sampling tab of Simulation Settings and save the workbook.
            1. This setting can be different in different workbooks.
            2. You can also set it in Application Settings, to apply to new models.
         3. If you can't change the workbook, click Yes each time the message appears.
         4. If the formula is actually correct, and is not contained in the list referenced above, please contact Tech Support by logging into the Lumivero Community Home Page and clicking on the Submit a Case button to fill out a form for assistance from the Support Team.

Related Articles:

Precedent Checking (Smart Sensitivity Analysis)

Excluding an Input from the Sensitivity Tornado