---
title: "ACE Analytics Standard Formats"
slug: "ace-analytics-standard-formats"
updated: 2023-04-24T12:58:03Z
published: 2023-04-24T12:58:03Z
canonical: "docs.interprose.com/ace-analytics-standard-formats"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.interprose.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ACE Analytics Standard Formats

The following standard formats are available, from a pull-down list, in Studio for elements' Format attribute value:

| **Type** | **Description** |
| --- | --- |
| < | Converts all characters to lower-case. |
| > | Converts all characters to upper-case. |
| Expanded Spaces | Preserves space characters that are normally collapsed by the web browser. *This formatting will not be applied if used with content that includes more than one @Data token.* |
| Preserve Line Feeds | Preserves line breaks (CTRL-ENTER). *This formatting will not be applied if used with content that includes more than one @Data token.* |
| HTML | Preserves HTML tags, embedding them rather than encoding them. Text appearance and alignment is affected by the tags; they are not seen in the text. |
| General Date | Display a date and/or time. For real numbers, display a date and time, for example, 4/3/93 05:34 PM. If there is no fractional part, display only a date, for example, 4/3/93. If there is no integer part, display time only, for example, 05:34 PM. Date display is determined by the web server's settings. |
| Long Date | Display a date according to the web server's Long Date format. |
| Medium Date | Display a date using the Medium Date format appropriate for the language version of the host application on the web server. |
| Short Date | Display a date using web servers's Short Date format. |
| Long Time | Display time using the web server's Long Time format; includes hours, minutes, seconds. |
| Medium Time | Display time in 12-hour format using hours and minutes and the AM/PM designator. |
| Short Time | Display time using the 24-hour format, for example, 17:45. |
| yyyy/MM/dd | A custom date/time format defined by the developer using the components described in the next section. |
| hh:mm | Display time as hours and minutes, with leading zeroes. Example: 01:08 |
| yyyy/MM/dd hh:mm:ss | Display date and time, with leading zeroes. Example: 2007/01/01 01:08:02 |
| General Number | Display number with no thousands separator. |
| Currency | Display number with thousands separator, if appropriate; display two digits to the right of the decimal separator. Output is based your system locale settings. |
| Fixed | Display at least one digit to the left and two digits to the right of the decimal separator. |
| Standard | Display number with thousands separator, at least one digit to the left and two digits to the right of the decimal separator. |
| Percent | Display number multiplied by 100 with a percent sign (**%**) appended to the right; always display two digits to the right of the decimal separator. |
| Scientific | Use standard scientific notation. |
| mp | Formats numbers by applying the appropriate "metric prefixes" (giga-, mega-, kilo-, etc.) . Example: "1,234,567" formatted with "$#.00mp" produces "$1.23M". More information about metric prefixes can be found [here](https://en.wikipedia.org/wiki/Metric_prefix). Customization of the mp format can be accomplished using the Globalization element's Metric Prefix String attribute. |
| mps3 | Identical to the mp format, but allows rounding to three significant digits. Example: A value of 123456, with format mps3, returns 123K. |
| ###,###,##0.00 | Display number with thousands separator for every three digits to left, at least one digit to the left and two digits to the right of the decimal separator. |
| Yes/No | Display **No** if number is 0; otherwise, display **Yes**. |
| True/False | Display **False** if number is 0; otherwise, display **True**. |
| On/Off | Display **Off** if number is 0; otherwise, display **On**. |

The **HTML** format, when used with a Label caption, allows you to embed HTML code in the report. This be used to accomplish things as simple as making part of a line bold-faced using tags, or as complicated as including scripts within tags for various purposes. When using the HTML format, ensure that you do not include a tag that might confuse the Server Engine when it generates its HTML output.

Hint: Use these standard date/time and numeric formats to improve performance with large reports.

Note that the standard numeric formats, such as Currency, may cause **rounding**, and this may affect aggregations and summaries of the data.