Troubleshoot Calculation Errors

If your calculation has an error, DAS will red-out the cell values that have an error in the grid.

To identify and resolve errors:

  1. Run your calculation.

  2. Right-click on calculation cells that are red.

  3. Read the message box instructions and optional resolution.

  4. Press "Edit Calculation" to correct the error.

Common errors include:

  • Invalid type conversion

  • Missing inputs

  • Blank inputs

  • Missing options

  • Circularly dependent calculations

Performance considerations

The calculation architecture is designed to provide maximum performance. This includes:

  1. Only re-calculating necessary columns.

  2. Caching results when appropriate (associated descriptions and table lookups).

  3. Taking minimum steps in repetitive calculations.

Overall, the result should be that adding new columns has little performance impact on your layout. Calculations can, however, impact performance if they are used improperly. The section that follows outlines best practices for using calculations:

  • Delete any calculation that you are not using.

  • Limit the number of Table Lookup calculations. A table lookup will query data from other tables. If this is done excessively, the overall performance of your report may suffer.

  • If you are querying against a large table (>1,000,000 rows), make sure that your report filters on at least one database column. You may filter calculation column results; however, the database itself cannot recognize these filters. Because calculations are derived data, filtering calculations will not result in a smaller set of rows retrieved from the database.