Category:

Miscellaneous

Formats a number using a mask.

Syntax

format_float(
  x Numeric,
  Mask String
): String

Parameters

x is a number to format.

Mask is a mask. For example, to always display two decimal places after the floating point, specify '0.00' mask.

Return value

Type: String. Returns the formatted value.

Examples of using

format_float(dataset_field_val(1, 'PaymentSum'), '0.00')
format_float(9999.798, '#,###,##0.00')