Suppress Rows of Zeros in Sage Intelligence Reports

Are you annoyed when you see a row of zeros on your financial statements? Would you prefer the rows not show up? You can hide the rows by following these steps:
1. Under “Properties” in a standard report, click the “Show Advanced” button.
2. On the “Run Add-Ins” line, select the “…” field.
3. Under “Select Add-In Library,” choose “Alchemex Add-In 1.”
4. Below “Select Add-In Library Module,” choose “General Excel Extensions Module.”
5. Under “Select Add-In Function,” choose “ZeroingII.”
6. Click “OK.”
7. At the “Add-In Function” menu, select “Fill in Defaults.”
8. Select “OK.”
Before you link the template, choose “Un-Link Template,” which allows you to relink the template using the macro-enabled Excel format. Then:
- Click “Yes.”
- Save the Excel template and choose the macro-enabled format.
- Click “OK” and “Yes” to allow the old sheet to be cleared.
You can now run the report without any rows of zeros.
Contact our team for more information.