Show TOC

Function documentationInclude Blank Rows or Columns Locate this document in the navigation structure

 

You can include blank rows or columns within a data range in an EvDRE report or input schedule.

Features

You can leave these rows or columns blank or insert formulas, without having to break the column or row key ranges into multiple ranges.

When you include a blank row or column in the RowKey range or ColKey range, the system does not apply the function to the corresponding row or column when it retrieves data.

When a blank cell displays, the system ignores the corresponding data range cells because there is no valid key associated with them. You can insert any text or formula into the cells and the system does not overwrite them.

If you enter formulas in the data range in cells where the row and column keys are valid, the system does one of the following:

  • If the workbook is a report (retrieves only), the system ignores values that contain formulas when it retrieves to the cell, and it preserves the formula (as if the key contained blank cells).

  • If the workbook is an input schedule (retrieves and sends), the system compares the retrieved values to the value calculated by the formula. If there is a difference, the system attaches a comment to the cell. When the system sends data values, it sends the values calculated by the formula to the database, in case of a discrepancy.

Inserting formulas

When you enter formulas in the data range in cells where the row and column keys are valid, the system does one of the following:

  • If the workbook is a report (retrieves only), the system ignores values that contain formulas when it retrieves to the cell, and it preserves the formula (as if the key contained blank cells).

  • If the workbook is an input schedule (retrieves and sends), the system compares values retrieved with the value calculated by the formula and if there is a difference, it attaches comment to the cell. When data values are sent, the values calculated by the formula are sent to the database, in case of a discrepancy. You can use this feature to calculate the subtotals immediately, as numbers

Activities

To include a blank row or column, select the cell before which you want to insert the blank row or column. Right-click and select   Insert   Shift cells right   (for columns) or Shift cells down (for rows), then choose OK.