NumericFormat

controls the way in which numbers are displayed syntax numericformat(inputnumber, formatspecifier, reqdecimalplaces, customformat) enabled for for a description of the business object categories, see notes on "enabled for" docid\ u26v9fecfs6ilwa0 pvjd business object category yes/no business rules before save rules yes business rules calculation rules (after save, with or without also recalculate on load) yes1 business rules calculation rules (before save or always, without also recalculate on load) yes business rules calculation rules (before save or always, with recalculate on load) yes1 business rules editing rules yes business rules initialization rules yes business rules read only rules yes business rules required rules yes business rules validation rules yes client expressions yes object permissions no services no ldap no mobile no quick actions (except ui quick actions) yes ui quick actions yes reports yes search/dashboard without field references no search/dashboard with field references no not fully supported in calculation rules that have a condition of after save or the also recalculate on load option selected it may fail if the rule's field is used in a grid, form, or saved search parameters parameter description inputnumber input value to format (number value) formatspecifier format to apply reqdecimalplaces (optional) number of decimal places default value is 2 customformat (optional) custom format return value returns a string form of a given number examples $(numericformat(123, 'custom', 2, '00000')) returns this value 00123 $(numericformat("98765 4321", "custom", 2, "## ## ##")) returns this value 9 87 65 $(numericformat("98765 43210", "number")) returns this value 98,765 43 formatspecifier the table below shows the supported options along with an example of each format example input example output number $(numericformat(12345 67890, "number", 1 )) 12,345 7 general $(numericformat(12345 67890, "general" )) 12345 6789 currency $(numericformat(12345 67890, "currency", 3 )) $12,345 678 fixedpoint $(numericformat(12345 67890, "fixed point", 3 )) 12345 679 percent $(numericformat(12345 67890, "percent" )) 1,234,567 89% scientific $(numericformat(12345 67890, "scientific" )) 1 234568e+ 004 hexadecimal $(numericformat(43981, "hexadecimal" )) abcd custom $(numericformat(98765 4321, "custom", 2, "## ## ##")) 9 87 65 requires knowledge of the legal net numeric formats for example, f3 would return 12345 679 see the microsoft documentation https //docs microsoft com/en us/dotnet/standard/base types/custom date and time format strings for more information