DECIMAL
The Essbase Report Writer DECIMAL command determines the number of decimal places to display in the report.
Syntax
{ DECIMAL decPlaces | VARIABLE [ columnN [columnN] ] }
Parameters
- decPlaces
-
Number of decimal places to display. Positive integer from 0 (the default) to 40. Specify either VARIABLE or decPlaces.
- VARIABLE
-
Allows the decimal to float; may switch to scientific notation (E+00 format) if necessary to display the significant digits of a number in the given column width.
- columnN
-
Optional. Space-separated list of columns to be affected. If omitted, all columns are affected.
Notes
If you specify columns in the DECIMAL command before designating them with a member selection, the column numbers apply to all selected columns with a number that is a multiple of the specified column number.
The total number of specified column numbers should not exceed the value of columnN.
Default Value
Positive integer from 0 (the default) to 40.
Example
{DECIMAL 2}
Displays the number 65.4365 as 65.44 in the final report.