format-currency-suffix
numeric →
format-currency-suffix(
symbol: text,
decimals?: integer,
separator?: text,
grouping?: text,
negative?: text
) → text
Formats a numeric value as currency with the symbol after the number. Rounds midpoint values away from zero and returns null for null input or invalid formatting options.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
symbol | text | Yes | Currency symbol placed next to the formatted number. |
decimals | integer | No | Number of decimal places from 0 to 28; defaults to 2. |
separator | text | No | Nonempty decimal separator; defaults to a point. |
grouping | text | No | Thousands separator; defaults to a comma. An empty string disables grouping. |
negative | text | No | One character prepended to negative amounts, or two characters enclosing them; defaults to a minus sign. |
Argument evaluation
symbol: Evaluated once, in parameter order, for a numeric input. Expressions retain the enclosing context; field references read that context rather than the number entering this call.decimals: Evaluated once, in parameter order, for a numeric input. Expressions retain the enclosing context; field references read that context rather than the number entering this call.separator: Evaluated once, in parameter order, for a numeric input. Expressions retain the enclosing context; field references read that context rather than the number entering this call.grouping: Evaluated once, in parameter order, for a numeric input. Expressions retain the enclosing context; field references read that context rather than the number entering this call.negative: Evaluated once, in parameter order, for a numeric input. Expressions retain the enclosing context; field references read that context rather than the number entering this call.
Examples
57123.4567 | numeric-to-format-currency-suffix("EUR", 2, ",", ".") → "57.123,46EUR"
-57123.4567 | numeric-to-format-currency-suffix("EUR", 2, ",", ".", "()") → "(57.123,46EUR)"
Kind: Function
Scope: numeric/formatting
Aliases: numeric-to-format-currency-suffix