Set Zero Value Display

Use

Using the Set Zero Value Display command (SET_ZERO_PRESENTATION), you can specify how zeros are to be displayed.

Command Parameters

The following information outlines the command parameters in the same sequence that they appear in the command wizard when you insert the command:

Parameter Description

Target Data Provider (TARGET_DATA_PROVIDER_REF_LIST)

 

Enter a list of all data providers the command applies to.

You specify the individual data providers in the Data Provided Affected parameter (TARGET_DATA_PROVIDER_REF).

Zero Presentation Format (ZERO_PRESENTATION)

You use this parameter to specify the format for the display of zero values:

  • Zero with Currency/Unit (NORMAL)

    If you choose this option, the zeros are displayed with the currency or unit, for example, EUR 0.00.

  • Zero without Currency/Unit (NO_CURRENCIES_UNITS)

    If you choose this option, the zeros are displayed without the currency or unit, for example, 0.00. 

  • Zero as Space (EMPTY_STRING)

    If you choose this option, cells containing zero values are empty.

  • Custom Text (CUSTOM_STRING)

    If you choose this option, in the String to Represent Zero Value parameter (ZERO_PRESENTATION_STRING), you can enter the relevant value (character, digit, or letter), such as an asterisk (*). Cells that contain a zero value are filled with this value.

String to Represent Zero Value (ZERO_PRESENTATION_STRING)

You can enter the appropriate text in this parameter.