> ## Documentation Index
> Fetch the complete documentation index at: https://docs.wisepim.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Numeric Operations

> Do math on numeric attributes across many products at once: add, subtract, multiply, divide, adjust by percentage, or cap values to a range.

Do math on numeric custom attributes across many products at once. Add, subtract, multiply, divide, adjust by a percentage, or cap values to a range.

## Run a numeric operation

<img className="block dark:hidden" src="https://mintcdn.com/swiftsyncai/60BB58903-ed2K97/images/marketing-screenshots/products/products-bulk-edit-numeric-operations-light-transparent.webp?fit=max&auto=format&n=60BB58903-ed2K97&q=85&s=5bdf2ce9921540fceb40015fb60145a4" alt="Bulk editing, Numeric Operations across many products at once in WISEPIM" width="2252" height="2004" data-path="images/marketing-screenshots/products/products-bulk-edit-numeric-operations-light-transparent.webp" />

<img className="hidden dark:block" src="https://mintcdn.com/swiftsyncai/60BB58903-ed2K97/images/marketing-screenshots/products/products-bulk-edit-numeric-operations-dark-transparent.webp?fit=max&auto=format&n=60BB58903-ed2K97&q=85&s=bf6c92d4f5746d719d96d06a0f09d5a7" alt="Bulk editing, Numeric Operations across many products at once in WISEPIM" width="2252" height="2004" data-path="images/marketing-screenshots/products/products-bulk-edit-numeric-operations-dark-transparent.webp" />

<Steps>
  <Step title="Select products">
    Check the products you want to update, or use filters and select all matching results.
  </Step>

  <Step title="Open Bulk Edit and choose Numeric Operations">
    Click **Bulk Edit**, then search for "Numeric Operations" or find it under **Attributes & Custom Fields**.
  </Step>

  <Step title="Select the numeric attribute">
    Choose from your numeric, decimal, or integer custom attributes.
  </Step>

  <Step title="Pick the operation and value">
    Select the math operation and enter the operand value.
  </Step>

  <Step title="Configure options and apply">
    Review the operation preview, then click **Apply**.
  </Step>
</Steps>

## Configuration options

### Operations

| Operation             | Description                                     | Example (value = 10)     |
| --------------------- | ----------------------------------------------- | ------------------------ |
| **Add**               | Add a value to the current number               | 100 → 110                |
| **Subtract**          | Subtract a value from the current number        | 100 → 90                 |
| **Multiply**          | Multiply the current number by a value          | 100 → 1000               |
| **Divide**            | Divide the current number by a value            | 100 → 10                 |
| **Increase by %**     | Increase by a percentage                        | 100 → 110                |
| **Decrease by %**     | Decrease by a percentage                        | 100 → 90                 |
| **Set minimum value** | Set a floor, so values below this are raised    | 50 → 50 (if min = 50)    |
| **Set maximum value** | Set a ceiling, so values above this are lowered | 150 → 150 (if max = 150) |

### Options

| Option                                      | Description                                                    | Default |
| ------------------------------------------- | -------------------------------------------------------------- | ------- |
| **Round result**                            | Round to the nearest whole number                              | Off     |
| **Skip products with zero or empty values** | Don't apply the operation to products with no value or zero    | On      |
| **Prevent division by zero**                | Skip division when the operand is zero (shown for divide only) | On      |

## Tips

* The operation preview shows the result on an example value (100), so you can verify the calculation before applying.
* Use **Set minimum value** and **Set maximum value** to cap values within a range. For example, keep a rating attribute between 1 and 5.
* **Skip products with zero or empty values** is on by default to prevent unintended results like multiplying zero.

## Related

<CardGroup cols={2}>
  <Card title="Change price" icon="tag" href="/en/essentials/bulk-editing/change-price">
    Adjust prices in bulk with percentage or fixed changes.
  </Card>

  <Card title="Set attribute" icon="pen" href="/en/essentials/bulk-editing/set-attribute">
    Set a fixed value for an attribute instead of calculating it.
  </Card>
</CardGroup>
