Who is this article for?

  Users who encounter the error when running report templates

When populating an audit report, you might encounter the error "Unable to execute mathematical function." This article describes how to troubleshoot the problem.

Issue

The application allows for the use of template documents which are automatically populated with audit data, typically for audit reports.

A problem can occur when negative values are used as risk or control scores. If these values are used in calculations within the template, you might receive the error message:  "Unable to Populate this document, the following error was returned:", with the inner exception "Unable to execute mathematical function".  For example:

Troubleshooting

To troubleshoot this issue:

1. Go to the Matrix Configurations screen
2. Select the matrix you are using
3. Look for negative values in the matrices

If you are using negative values, please contact us and we will work with our Technical Services team to determine what changes can be made to the template.

If you are not using negative values as risk/control scores, further troubleshooting is required. Typically, we will need to:

1. Test whether the original template, as supplied by us, fails with the same error.
2. Test with a series of template versions that incrementally remove sections of code to locate the section causing the error.
3. Examine the identified section for values involved in the failing calculation, and assess how they are impacting the calculation and what resolution can be put in place.

Please contact Ideagen Support for further troubleshooting assistance.