> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Calculate Inventory Value

## ${color}[#1a63a5](Export Inventory and Calculate Inventory Value)

In this tutorial, you’ll learn how to **calculate the inventory value** of your stock using **DataChamp**.
Inventory value refers to the **total cost of all products currently in stock**.  

It’s calculated using the formula:
`Inventory Value = Available Quantity × Unit Cost`

${youtube}[](ezWIwrFY4Ec)

##### ${color}[#1a63a5](Step 1: Create a New Report)

1. Create a new report in Datachamp and select **"Locations"** as the report type.
2. Add the columns you need:
* **Location**
* **Product Title**
* **Unit Cost**
* **Available**


##### ${color}[#1a63a5](Step 2: Add a Custom Column)

We now create a calculated column to compute the inventory value.

| Custom Column Name | Value | Purpose |
| ---- |
| Inventory Value | [[ {{Available}} * {{Unit Cost}} ]]]` | Multiplies stock quantity by unit cost |
 
In **DataChamp**, use double **square brackets** `[[]]` to write formulas and double **curly brackets** `{{}}` to reference column names.

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/scr-20250805-lfkh_18kk66l.png)


##### ${color}[#1a63a5](Step 4: Add a Filter to Show In-Stock Products Only)

To limit the report to **only available stock**, apply the following filter:

| Filter | Condition | Value |
| ---- |
| Available | equals or more than | 1 |

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/scr-20250805-leye_1y1w5v1.png)


##### ${color}[#1a63a5](Step 5: Preview and Save the Report)

1. Preview the report
2. Give your report a clear name, such as: **“Inventory Value”**
3. Click **Save** and **Run Report**.