_format

Associates a format with the expression. The format_keyword can be PERCENTAGE_0, PERCENTAGE_1, or PERCENTAGE_2. PERCENTAGE_1 returns a percentage with one digit to the right of the decimal point, PERCENTAGE_2 returns a percentage with two digits to the right of the decimal point, and PERCENTAGE_3 returns a percentage value out of one with three digits to the right of the decimal point (for example, 0.965).

Syntax

_format ( expression , format_keyword  )

Example

_format ( [Unit Sale Price] / [Unit Price] , PERCENTAGE_2 )

Result

75.12%