Skip to content

Latest commit

 

History

History
73 lines (46 loc) · 2.06 KB

er-functions-text-numberformat.md

File metadata and controls

73 lines (46 loc) · 2.06 KB
Raw
title description author ms.author ms.topic ms.date ms.reviewer audience ms.search.region ms.search.validFrom ms.search.form ms.dyn365.ops.version ms.assetid
NUMBERFORMAT ER function
Learn about how the NUMBERFORMAT Electronic reporting (ER) function is used, including syntax strings, arguments, return values, usage notes, and examples.
kfend
filatovm
conceptual
12/10/2019
johnmichalak
IT Pro
Global
2016-02-28
ERDataModelDesigner, ERExpressionDesignerFormula, ERMappedFormatDesigner, ERModelMappingDesigner
AX 7.0.0
24223e13-727a-4be6-a22d-4d427f504ac9

NUMBERFORMAT ER function

[!include banner]

The NUMBERFORMAT function returns a String value that presents the specified number in the specified format and in an optionally specified culture. For information about the supported formats, see standard and custom.

Syntax 1

NUMBERFORMAT (number, format)

Syntax 2

NUMBERFORMAT (number, format, culture)

Arguments

number: Integer or Real

A numeric value that specifies the number that must be formatted.

format : String

A String value that represents the format.

culture: String

A String value that represents the culture to use for formatting.

Return values

String

The resulting text value.

Usage notes

If the culture isn't defined as an argument of the called function, the context that this function is run in determines the culture that is used to format numbers.

Example 1

For the EN-US culture, NUMBERFORMAT (0.45, "p") returns "45.00 %", and NUMBERFORMAT (10.45, "#") returns "10".

Example 2

NUMBERFORMAT (10/3, "F2", "de") returns 3,33, whereas NUMBERFORMAT (10/3, "F2", "en-us") returns 3.33.

Additional resources

Text functions

[!INCLUDEfooter-include]