Custom Style Zeros in Templates

Overview

Qvinci's Report Editor allows for templates to have custom styling edits applied to cells which are null or contain zeros. This means that a blank cell, or a cell with a zero value, can be styled to appear as a dash, 0, 0.00, $0.00, $0, or a blank, etc. 

Enable Format Customizer to Style Empty Cells

By default, the templates that are created in Qvinci will write null values, or blanks, as the format for financial cells that do not contain a value. Enabling the zero-functionality toggle provides a user with the means for styling these blank cells in a preferred manner. 

Step 1. After logging in to Qvinci, go to Reports & Libraries > Libraries.

Step 2. Locate the template you wish to edit from either the Mine tab or Qvinci Gallery.

Step 3. Press the blue edit button on a template you wish to open for editing.

Step 4. Upon opening, migrate to the Report Options button in the top-left corner of the template.

Step 5. Inside Report Options, check the box that says, "Use Format Customizer to Show Zeros in Empty Cells" and press the Submit button.

Step 6. Click the green Save button in the bottom-left section of the menu.

Step 7. The user has just enabled the styling of blank cells and may now do so by using the Numbers tab.

Step 8. View this article to learn how to apply cell formatting.

Have Questions?
We're More Than Happy to Help

Schedule a Call with Customer Success below, email us at support@qvinci.com or call us at 1-512-637-7337 Ext. 1 Available M-F, 7:30am-6:30pm CT and it is always FREE!

Schedule an Appointment with Customer Success