ZEROTEXT

Replaces zero data values with a text string if a zero data value is output.

Syntax

{ ZEROTEXT [ "text" ] }

text Optional. Text string, in quotation marks, to use in place of the 0 value.

Default Value

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

Description

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.

Example

{ZEROTEXT "-"}
changes a 0 value to -.

See Also

MISSINGTEXT

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com