Contact Us
Index
Version 25.3
Version 20.3 Version 20.4 Version 21.1 Version 25.2 Version 25.4 Version 26.1
Contact Us
Discover Period Names
Discover Segment Properties
Expand and Explode
Explode Segment Values
Explode Segment Value Hierarchy
Expand Segment Value Hierarchy
Expand Segment Values
Discover Segment Values
Discover Level
List of Values – Create
Ledger Set
Segment End Date
Next Segment Value
Account Type
Segment Tree
Parent Flag
Enabled Flag
Segment Start Date
Period Name
Financial Category
Period Name by Date
Period Start Date
Period End Date
Get Balance
Multiple Ledgers
Get Balance Options
Ledger Name
Period Offset
Functional Currency
Previous Segment Value
Segment Description
Analyze Balances
Drill to Journal or Subledger
Drill Using a Saved Template
Drill Criteria Sheets
Drill Criteria – Journal Extract
Drill Criteria – Balance
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand User Options
Other Tools
Hide Zeros
Advanced Options
Email
Drilldowns
Parameters
Source Report
Named Ranges
Execution
Load and Validation
Running the Scheduler
Create Schedule
SMTP Email Settings
Combine Text
Last Refreshed By
Split Text
Last Refreshed Time
Snapshot
Common Options
Shared Templates Drive
File Server
Oracle Cloud Connector Database
Navigator
Open a File
Create a File
Edit a File
Drive Types
Dropbox
Delete a File
System Administrator Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator User Options
System Administrator Server Information
Execute Report
Create Report
Drill to Saved Template
Drill on Function
Modify Run Report Function
Run Report Order
Run Report Filter
Insert Run Report Function
Calculate Reports Wand Functions
Calculation Mode
Template Manager
Report Editor
Parameter List
Reports Wand User Options
Create List of Values
Show List of Values
Clean Template

Hide Zeros

Hide Zeros is used to hide rows on a report that only contain zero values. This is very useful for formatting a report which includes many rows where, for example, a number of accounts are not used in a particular cost centre or have no balances in a certain period. At the click of a button you can hide all the rows that contain only zeros.

  1. Select a range on the report.
  2. Navigate to GL Wand | Tools | Other | Hide Zeros.
  3. GL Wand will now process the selected range, and hide any rows that only have zero values in them.

Make sure you select the entire report range on those rows, as any cells outside the range will not be checked. If there are non-zero values on the row that are not selected, the row will be hidden.

Undo Hide Zeros

Click this button to automatically undo the last Hide Zeros operation.