User Tools

Site Tools


token:CalculateFormat

CalculateFormat Token

The %CalculateFormat%<formula>%<format>% token (v8+) returns the numeric result of performing a calculation. The formula is the same as for the Calculate token.

The <format> is either one of these specific localized formats:

  • Decimal
  • Currency
  • Percent
  • Scientific
  • Ordinal
  • CurrencyISOCode
  • CurrencyPlural
  • CurrencyAccounting

or a format pattern according to Unicode Technical Standard #35.

Example patterns and results for the number 1234.567 in French locale are:

FormatAustralia France
#,##0.##
#,##0.###
###0.#####
###0.0000#
00000.0000
1,234.57
1,234.567
1234.567
1234.5670
01234.5670
1 234,57
1 234,567
1234,567
1234,5670
01234,5670

See Also

Tokens

token/CalculateFormat.txt · Last modified: 2019/08/06 20:51 by peternlewis