---
schema_version: "1"
id: 2c268e01ec71bc62f0e6795d857d4b7884ad5c57e43bb7fb0723ec15fa16f485
title: Multiply Measures by a Fixed Amount
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_xmd/guides/concept/bi-xmd-multiply-by-fixed-amount.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-xmd/guide/bi-xmd-multiply-by-fixed-amount.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 8fb52263a83e94618414c06f82412426a3c37595ee29a1c707a2df9c2d7ecf1f
products:
  - Analytics Extended Metadata (XMD) Developer Guide
  - analytics
---

# Multiply Measures by a Fixed Amount

You can multiply the values of a measure or derived measure by a fixed amount. For example, you can use the multiplier to convert a field’s decimal values to percents.

In this example lens, the values in the Discount column are shown as decimal values.

![The values table shows the Discount field values in decimal form.](https://developer.salesforce.com/media/bi_dev_guide_xmd/bi_xmd_multiply_by_amount_before.png)

To change the decimal value to a percentage, modify the XMD file as shown in this example. Add “%” after the value, and change the field label to "Discount %".

```nolang
{
  “Measures” : [
    {
      "field": "Discount",
      "format": {
        "customFormat": "[\"##.##%\",100]"
      },
      "label": "Discount %",
      "showInExplorer": true
    }
],

```

The Discount column now has the label Discount %, and the values are in percentages.

![The values table shows the Discount field values as a percent.](https://developer.salesforce.com/media/bi_dev_guide_xmd/bi_xmd_multiply_by_amount_after.png)

**note:** If a measure field has a multiplier of “0”, downloading the data to an `.xls` or `.csv` file results in all values for that field displaying as “0”. A “0” multiplier has this format: `"format":{"customFormat":"[\"#,###\",0]}`.

**See Also**

- [Measures and Derived Measures in XMD](https://developer.salesforce.com/docs/analytics/bi-dev-guide-xmd/reference/bi-xmd-reference-measures.md)