An Explanation of Standard Formatting Functionality

The Format functionality contains the following tabs:

Text

• STYLE - Apply bold, italic, underline or double underline. Select a font, font size, font color, and background color.

• ALIGNMENT & INDENTATION - Select to justify right, center or left. Select right or left indent.

• BORDERS - Select border options and border color.

Data

NUMBER FORMAT

• Display as - Select to display the cell contents in number, currency, or percentage format.

• Show Zero As - Select how you want to display zero values.

• Decimal Places - Choose up to 6 decimal places for numbers. Decimal places are displayed in Dynamic Reports based upon whether Report Sets are used or not. When Report Sets are not used in a Dynamic Report, decimal places displayed in quick functions are identical to those in the Dynamic Report. When Report Sets are used, decimal places in quick functions allow for the maximum number of decimal places allowed for a selected range.

• Negative No. - Determines the format of the negative number. You can display negative numbers in parentheses, in color, or both. If you choose Absolute as the format, negative numbers will be displayed as positive numbers without any formatting.

• Number Scale - Defines a value that the numbers displayed in the Dynamic Report must be multiplied by to get the actual number.

• Display Thousand - Determines whether a comma is to be placed to separate thousands.

• Preview - Displays the format for negative numbers based on your selections.

Other

SUPPRESS

• Empty Rows - Select to exclude empty rows from the report .

• Empty Columns - Select to exclude empty rows from the report.

DRILL THROUGH -

Select to drill through Translation and Transaction details. Expand (drill down) and collapse (drill up) report detail.

Transaction and Translation data is not stored in the OLAP Cube from which the Dynamic Reports pull their data, which is why drill-through is required. This means that you cannot run a Dynamic Report to output Transaction or Translation data. For example, lets say you have a travel line item in your report that shows up as a number. You have to drill down to see what transaction data makes up that number. You cannot generate a report to open and display at the transaction level.