ZEROTEXT

The ZEROTEXT Report Writer command in Essbase replaces zero data values with a text string, if a zero data value is output.

Syntax

{ ZEROTEXT [ "text" ] }

Parameters

text: Optional. String, in quotation marks, to use in place of 0.

Notes

All data values less than .00000000000001 and greater than -.00000000000001 are treated as 0, as well as all data values that would be displayed as 0, regardless of their true value.

Default Value

If you do not specify text, the default 0 is restored.

Example

{ZEROTEXT "-"}

changes a 0 value to -.

Related Topics

MISSINGTEXT