The Suppress field allows you to indicate whether the column should be visible on the report.
The Suppress drop-down box includes the following options:
•Blank: This is the default selection indicating that no option for suppression of the column has been made.
•Always: This option indicates that the column should always be suppressed and should never appear on the report.
•Never: This option indicates that the column should never be suppressed and should always appear on the report.
•When Zero: This option indicates that the column should be suppressed when the values are zero and should not appear on the report.
•< Report Period: This option indicates that the column will be hidden where the column’s period is less than the period specified when executing the report.
•> Report Period: This option indicates that the column will be hidden where the column’s period is greater than the period specified when executing the report.
•= Report Period: This option indicates that the column will be hidden where the column’s period is equal to the period specified when executing the report.
•<= Report Period: This option indicates that the column will be hidden where the column’s period is less than or equal to the period specified when executing the report.
•>= Report Period: This option indicates that the column will be hidden where the column’s period is greater than or equal to the period specified when executing the report.
•<> Report Period: This option indicates that the column will be hidden where the column’s period is not equal to the period specified when executing the report.
When column values are suppressed using the Suppress option, calculations for lines or columns will skip the hidden columns’ values, depending on the specific operators defined in the formula or range is used. This does not require that you to modify your calculations, only that you understand that the use of specific operators (versus ranges) is different when Suppress is used.
Prospero also allows you to suppress a column based on the column's period value in relation to the report period. In short, the referenced period could be “greater than” the report period or "less than" the report period, based on the operator you select. This capability is useful to allow reports to change dynamically as the reporting year progresses. In this instance, the Suppress logic will allow the year and period field to be populated on the calculated columns and then reference that data to determine visibility based on conditional suppression logic. (Setting a year and/or period in the column will have no other impact on the calculated column other than being used as criteria for indicating if a column is conditionally suppressed.)
If the Column Suppress Field is selected, this field will not appear in any Excel export.
For more information on creating calculations and the behavior of the Suppress field options, refer to the section Using Ranges in Formulas.