ACE Analytics Standard Formats

Updated on 24 Apr 2023
2 Minutes to read
Contributors

Article summary

Did you find this summary helpful?

Thank you for your feedback

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. 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.

Was this article helpful?

What's Next

ACE Analytics About Formatting