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

# Added Value

You will very often find yourself wanting to add new columns to your dataset. In this lesson, we'll cover the [New Column](/tools/new/columns) tool. This is a very versatile tool that can be used in a lot of different ways.

<Frame>
  <iframe className="w-full aspect-video" src="https://player.mux.com/WlH46uoLl9PV901AKu7yHR1yXRUi0101XfEVDC2Zyv5mNQ?metadata-video-title=Tools+-+Added+Value&video-title=Tools+-+Added+Value&autoplay=1&muted=1&accent-color=%232b8761" allow="accelerometer; gyroscope; autoplay; encrypted-media; picture-in-picture;" allowfullscreen="true" />
</Frame>

## Exercise

We're working with the *ORDERS* dataset and you want to get the result shown below. We ended up with 227.597 rows and used five tools to get the result.

A couple of hints. You can round numeric columns in a couple of ways: with the [Transform](/tools/basics/transform) tool or with the [.ROUND](/canvas/syntax/syntax-operations) syntax. The [TEXT()](/canvas/syntax/syntax-functions) function could also be helpful to convert a number to a string - you can also use the Column tool if you prefer.

<Frame>
  <img src="https://mintcdn.com/less-51/7vxLoN8O_CeWSGG4/images/academy/beginner/2result.png?fit=max&auto=format&n=7vxLoN8O_CeWSGG4&q=85&s=7ffb2d57eab92d79c3584866b9a1d3fe" width="3000" height="440" data-path="images/academy/beginner/2result.png" />
</Frame>

We use a 0.85 exchange rate to go from USD to EUR. We only want orders that are currently fulfilled (*F* in the *O\_ORDERSTATUS* column) and where the order is placed on or after 1994-01-01 and before or on 1994-12-31.

## Solution

<Frame>
  <iframe className="w-full aspect-video" src="https://player.mux.com/WZY5oFwA582FQ67TR3qETpMnGRx7IP2O47EkRIFAJh8?metadata-video-title=Solution+-+Added+Value&video-title=Solution+-+Added+Value&accent-color=%232b8761&&poster=https://less-docs.s3.eu-central-1.amazonaws.com/SolutionAddedValue.png" allow="accelerometer; gyroscope; encrypted-media; picture-in-picture;" allowfullscreen="true" />
</Frame>
