Formatting Measure Type Column

Measure type column values can be formatted based on the following different options:

Type

The value display type of measure column can be defined based on the displayed data. For example, if you display the sales amount column, then the type can be defined as Currency.

Representation

The value display format can be defined by the representation. For example, by selecting thousands, the value 10,000 will be displayed as 10K.

Lakhs and Crores support

Cultures from countries including India, Pakistan, Bangladesh, and Nepal have Lakhs and Crores support. For example, the value of 1,00,000 is displayed as 1L.

When support culture is selected, there will be a checkbox that is needed to enable lakhs and crores along with auto representation. This helps in handling existing value.

Decimal places

You can set the decimal places explicitly when the representation is set with options other than Auto.

Currency culture

You can set the currency value culture when the value display type is set as Currency.

Append text

You can append text, character, number, or symbol either at start or at the end of the values.

Preview

This field provides the preview of display value in the Measure Formatting dialog based on the settings.