Error Messages/40623

Warning message

The Table in Energy_requirement contains one or more Undefined cells. The first Undefined cell is at the following coordinate:
Prod='Hyperphase discombobulator'
Instance=4

Buttons: Edit Definition, Continue Anyway and Cancel.

Description

An edit table has one or more blank cells. A blank cell is an empty cell with no data. This warning can help you avoid problems that arise when you add an element to and index, but forget to fill in the corresponding cells in edit tables for inputs that use the index.

If you press Continue Anyway, blank cells in the current table evaluate to Null.

Press Edit Definition to stop and provide data for the missing cell(s). This will, of course, also cancel the current in-progress computation.

Press Cancel to cancel the current in-progress computation.

Using blank cells

The use of blank cells usually requires you to configure your model to do so. One source of error in a model is adding an element to an index, but not providing the input values for the new case in each input table. The option to use blank cells is a way to prevent this error from occurring. If you want to turn this feature on (it is not on by default), you can to this from the Typescript Window as follows.

  1. Press F12 to open the Typescript Window.
  2. Type: Sys_TableCellDefault:

Take note that there is a colon at the end of that command. This is setting the global default to blank. To restore this to its default, type:

Sys_TableCellDefault:0

Which populates new cells with 0. To customize this default for a single particular table, in the Typescript Window type:

TableCellDefault «ident»:""

You can also set this from the Analytica UI by first turning on Cell Default in the Attributes dialog and then editing the Cell Defaults attribute.

Configuring your model to ignore this warning

This warning is special among warnings, in that it is controlled separately. The standard IgnoreWarnings and Show result warnings don't apply to it. It is a warning that you may want to retain even when other warnings are turned off, or vise versa.

If you don't want this to appear when blank cells are present, you can Suppress Empty Cell Warnings like this either globally (for all tables in the model) or for a particular table only. Blank cells will evaluate to Null. At present, this must be configured from the Typescript Window. Follow these steps:

  1. Cancel the current in-progress computation.
  2. Open the typescript window by pressing F12.
  3. To disable these warnings globally, type:
    Sys_WarnUndefCell:0
  4. or, to disable for one particular table type:
    WarnUndefCell «ident»:0

See Also

Comments


You are not allowed to post comments.