Using AX Web Client > Interpretations and Visualizations > Viewing table data > Data formatting options

Data formatting options

Numeric, text, and date fields support a number of different formatting options that are useful in different situations.

Numeric data formats

Supported formats

Numeric fields support the following formatting options:

Rounding options

Any format can be displayed as the exact number, rounded to the nearest whole number, or rounded to two decimal places.

Note

Rounding is to the nearest decimal.

Numeric separators

Numeric separators for the interpretation are based on your browser settings. This configuration is retained when you save interpretations, providing the same view to others who access the interpretation.

Text data formats

Text data fields support plain text or a subset of HTML elements.

Supported HTML elements

Image tag src attributes may reference images hosted on external domains.

Note

If you click an HTML link in the table, the page opens within the Table View. Use the browser back button to navigate back to the table.

When to use HTML formatting

HTML formatting is useful for:

Date and datetime data formats

Date and datetime fields support a number of common date formats that are used in different locales and by different systems.

Format column data

Note

Custom formatting applied in the Table View does not persist in charts or column overview visualizations. Visualizations display data in the default format.

  1. Click the header of the column you want to format and in the dialog box select Options.
  2. From the list of display format options, select the format you want to apply to the data in the column.

    Result The window closes and the formatting is applied to the table.

  3. To save the interpretation with the formatting, from the Save list, select Save.