Format Data

Format data in a report to improve readability. For example, you can show all date values in the order year, month, and day. If you do not set Data Format properties here, data is formatted according to the properties set in the model. If the properties were not set in the model, data is formatted according to the International Components for Unicode (ICU) formats.

Special cells, such as overflow or underflow, errors, or not applicable values appear with two dash (--) characters unless you override them.

You can also format data based on a condition or specify the format for a particular object .

Formatting data includes

• setting default data formats
• understanding the data format for numbers
• specify the data format for an object
• understanding locale-sensitive properties
• suppressing empty cells
• specify what appears for data containers that have no data
• use patterns to format data

If you create a calculation that uses mixed currency values, an asterisk character (*) appears as the unit of measure. To remove the asterisk character, change the format of the corresponding row or column.