Page History

PERCENTAGE

This function converts a value of another data type into a percentage data type. 

Syntax

PERCENTAGE(string, [format], [locale])
PERCENTAGE(integer)
PERCENTAGE(number)

Inputs

• value - The value of the data type that is converted to percentage. 

• format (optional) - The format used for conversion. Format must be enclosed by quotes, e.g. “00.00”.

• locale (optional) - Locale specifies a combination of language and country. A locale in the option set will override the one that is used as default in the project. Commonly used are en-US, en-GB, nl-NL, nl-BE, fr-FR. The list of language codes can be found here. A list of country codes can be found here.

Default formats

For all conversion functions that use a string as parameter, the [format] describes the format in which the input string value parameter is in. When not specifying a format, by default this format is used: 

• string to percentage - 2 digits. 

Return type

• percentage

Examples

• PERCENTAGE ("22") results in a percentage value of 22,00 (default format is used).