Skip to content

Text Formats

There are numerous formats for presenting dates, numbers, currencies, and text, each tailored to specific functional requirements.

Format Description Unformatted Value Formatted Value
Number formats
n;2 Two decimals 1537.2598 1,537.26
n;0 No decimals 1537.2598 1,537
n;6 High precision (6 digits) 1537.2598 1,537.259800
n;2;6 Flex precision (min 2, max 6 decimals) 1537.2598 1,537.2598
number;0;2;c Compact Number 1537.2598 1.54K
zeropad;2 Zero pad (2 digits) 5 05
Percent formats
p;2 Default 0.994587 99.46%
ps;2 Add percent sign 0.994587 0.99%
percentnosign;2 Hide percent sign 0.994587 99.46
p;0 No decimals 0.994587 99%
p;1 One decimal 0.994587 99.5%
Date formats
d Default date 2024-04-18T22:46:27.639Z 04/19/2024
dt Default date and time 2024-04-18T22:46:27.639Z 04/19/2024 10:46 PM
dt;MMMyy Month name and Year 2024-04-18T22:46:27.639Z Apr 24
dt;MMyy Month number and Year 2024-04-18T22:46:27.639Z 04/24
dt;MMMMyyyy Long Month name and Year 2024-04-18T22:46:27.639Z April 2024
dt;yyyyMMddHHmm Full date time 2024-04-18T22:46:27.639Z Apr 18, 2024 10:46 PM
dateq Year Quarter 2024-04-18T22:46:27.639Z Q2 2024
yearperiod;2 2 Years Period 2024-04-18T22:46:27.639Z 2024-2026
yearperiod;4 4 years Period 2024-04-18T22:46:27.639Z 2024-2028
Currency formats
currency;;0;2 Currency (Default) 137890.95 $137,890.95
currency;USD;0;2 Currency USD 137890.95 $137,890.95
currency;EUR;0;2 Currency EUR 137890.95 €137,890.95
currency;USD;0;2;c Compact Currency USD 137890.95 $137.89K
currency;EUR;0;2;c Compact Currency EUR 137890.95 €137.89K
Text formats
suffix; kg Suffix 15 15 kg
wrap;(;) Wrap Category (Category)
ellipsis;10 Ellipsis More than 10 letters More th...
ellipsis;10;middle Ellipsis (middle) More than 10 letters More...ers
ellipsis;10;start Ellipsis (start) More than 10 letters ...letters

DateTime Format Specifiers

The dt format supports custom patterns using these specifiers. Separators and formatting are automatically applied based on the selected report language.

Specifier Description
Year
YYYY Full year
YY Short year
Month
MMMM Long month name
MMM Short month name
MM Two-digit month
M Numeric month
Day
DDDD Full day name
DDD Short day name
DD Two-digit day
D Numeric day
Time
HH 24-hour format hours
H 24-hour format hours (no padding)
hh 12-hour format hours
h 12-hour format hours (no padding)
mm Minutes
m Minutes (no padding)
ss Seconds
s Seconds (no padding)
A AM/PM (uppercase)
a am/pm (lowercase)

Pattern Examples:

  • dt;yyyyMMdd - Year, month, day
  • dt;MMMMyyyy - Long month name and year
  • dt;DDDDMMMDyyyy - Day name, month name, day, year
  • dt;HHmm - Hours and minutes (24-hour)
  • dt;hmmA - Hours, minutes, AM/PM (12-hour)

The actual output format (separators, spacing) depends on the selected report language.

Number Format Parameters

Number formats support flexible decimal precision and formatting flags using the pattern n;min;max;flags (or number;min;max;flags).

Parameters:

  • min - Minimum number of decimal places
  • max - Maximum number of decimal places
  • flags - Formatting options (can be combined)
  • Short form: n;2 sets both min and max to 2 decimals (same as n;2;2)

Available Flags:

  • c - Compact format (displays large numbers as K, M, etc.)
  • a - Accounting format (negative numbers in parentheses)
  • + - Always show sign (+ for positive, - for negative) - signDisplay = "exceptZero"

Examples:

  • n;0;2 - 0-2 decimal places: 1537.2598 → 1,537.26
  • n;2;2 - Exactly 2 decimal places: 1537.2 → 1,537.20
  • n;0;2;c - Compact with 0-2 decimals: 1537.2598 → 1.54K
  • n;0;2;+ - Show sign with 0-2 decimals: 1537.26 → +1,537.26
  • n;0;2;+c - Sign + compact: 1325 → +1.33K
  • n;0;2;a - Accounting format: -1537.26 → (1,537.26)
  • n;0;2;ac+ - All flags combined: -1325 → +(1.33K)

Currency Format Parameters

Currency formats follow the same parameter structure as numbers: currency;{currency-code};{min-decimals};{max-decimals};{flags} (or c;{currency-code};{min-decimals};{max-decimals};{flags}).

Parameters:

  • currency-code - ISO currency code (USD, EUR, etc.) - leave empty for default
  • min - Minimum number of decimal places
  • max - Maximum number of decimal places
  • flags - Same formatting flags as numbers (c, a, +)
  • Short form: currency;USD;2 sets both min and max to 2 decimals

Examples:

  • currency;USD;0;2 - USD with 0-2 decimals: 137890.95 → $137,890.95
  • currency;EUR;2 - EUR with exactly 2 decimals: 137890.9 → €137,890.90
  • currency;USD;0;2;c - Compact USD: 137890.95 → $137.89K
  • currency;EUR;0;2;+ - EUR with sign: 137890.95 → +€137,890.95
  • currency;;0;2 - Default currency: 137890.95 → $137,890.95