# Number

Numeric data can be entered and formatted in a variety of ways. You can insert a new empty series, copy from another series, or import from a file.

Let's first look at the steps to insert a numeric data input column. The steps to copy another column as a data input column are covered in '[Copy as data input](#id-4.-copy-as-data-input)'.

## 1. Create a column

Select the 'Number' option in the Data Input dropdown. You will see four different options to create a column:  Insert a new empty series, Copy from another series, Advanced copy, and Import from file. Let's go through each of these methods.

### i) Insert a new empty series

If you select this option, a visual measure gets inserted as shown below. There is a side panel that provides several customization options.

#### The available properties are:

* **Insert as**: A [column or measure](https://docs.inforiver.com/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-manual-input-columns/..#a-insert-as) can be inserted. If there is a column hierarchy, the input column is inserted for each category. In case of no column hierarchy, a single column is inserted.
* **Input type**: The type of [data input column](https://docs.inforiver.com/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-manual-input-columns); can be changed from the initial selection before creating the column by clicking on 'Create'.&#x20;
* **Row aggregation type**: By default, totals, and subtotals are defined as the sum of child rows as shown [here](#i-row-aggregation-type). There are several other options such as average, minimum, maximum, etc. that are explained in detail [here](https://docs.inforiver.com/premium-table/working-with-premium-table/manage-aggregations).
* **Distribute parent value to children**: The values entered at a parent level are distributed to the child rows [when enabled](#ii-distribute-parent-value-to-children). This is very useful when creating budgets or forecasts.&#x20;
* **Minimum Value**: You can optionally [specify the minimum threshold value](#iii-min-and-max-range) for the leaf-level cells, which can be a static number or value from the selected measure. When set, Inforiver ensures that both user input and the allocations to these cells are always more than this value.
* **Maximum Value**: You can optionally [specify the maximum threshold value](#iii-min-and-max-range) for the leaf-level cells, which can be a static number or value from the selected measure. When set, Inforiver ensures that both user input and the allocations to these cells are always less than this value.
* **Default Value**: In cells where the user has not entered any value, instead of displaying empty cells you can choose to display a default value. The default value can be selected from any native or formula measure as explained [here](#iv-default-value). If the underlying native or formula measure is updated, the default value will reflect the latest value.
* **Allow input**: By default, inputs are enabled in both read and edit modes. But, based on your requirement, you can [allow inputs](https://docs.inforiver.com/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-manual-input-columns/..#b-allow-input) only in edit mode or based on a formula.&#x20;
* **Description**: Option to add a note for reference.

Change the title and go with the default for the other properties. Click 'Create'.

The measure gets inserted.

To learn to enter a value in an empty numeric column in the [Enter a value](#id-2.-enter-a-value) section.

### ii) Copy from another series

If you select this option, you will see a sub-option with all the measures/forecasts present in the report. You can select any series to create a numeric column with all the data copied from the chosen series. The values from the measure chosen as the source will serve as initial values only. If there are changes to the source measure, these changes will not be reflected in the data input field.

A visual measure gets inserted as shown below. There is a side panel that provides several customization options. Change the title and go with the default for the other properties. Click 'Create'.

The newly created numeric measure will be pre-populated with the data of the chosen series.

In the below image, a numeric measure is created by copying the data from '2022 Actuals' and the created column is pre-populated with the copied data.

### iii) Import from file

You can also upload the data for the input columns by importing it through a .csv file. Choose **Import from file.**

Download the template, save it, and enter your data in the file.

After entering and saving the data, click **Browse** and select the saved file.&#x20;

Click **Preview.**

The measures are inserted as shown below. You can make any changes if necessary and then click **Create.**

## 2. Enter a value

To enter a value, double-click a cell and type in the formula bar that opens on the top.&#x20;

You can also enter values directly in the cell as shown below.

The entered value is captured, and it is also automatically rolled up to the parent as well as distributed to the child nodes if applicable.

## 3. Properties

You can modify the properties of a previously created data input column in the side panel. To open it, click on **Manage Measures** and the 'Pencil' icon as highlighted.

The side panel opens. The input type is greyed out. This is because once a data input column is created, you cannot change its type. You can make any necessary changes and click **Update**.

We have already discussed an overview of the properties [here](#the-available-properties-are). Here we will discuss a few properties in detail.

### i) Row aggregation type&#x20;

Row aggregation type defines the aggregation method to be applied for the total rows. By default, the total rows are calculated as the sum of the child rows.

To change the aggregation method, click the **Row aggregation type** dropdown in the side panel. Choose one from the types available and click **Update**.&#x20;

{% hint style="info" %}
To understand the different aggregations, you can refer to [this section.](https://docs.inforiver.com/premium-table/working-with-premium-table/manage-aggregations)
{% endhint %}

In the below image, 'Maximum' has been chosen. The highlighted cells, which are the row subtotals, get updated.

### ii) Distribute parent value to children

When a value is entered in a subtotal or total row, the value can be distributed to the child rows.&#x20;

There are several other ways to distribute values which are covered in [Budgeting & allocations](https://docs.inforiver.com/premium-table/working-with-premium-table/6.-planning-budgeting-and-forecasting/budgeting-and-allocations).&#x20;

{% hint style="info" %}
**Sum** and **Weighted Average** are the only row aggregation methods that allow allocations/distributions from total cells to child rows.
{% endhint %}

This distribution can be disabled if not required for certain scenarios. Uncheck the 'Distribute parent value to children' checkbox.

### iii) Min and max range

When you need to define a range for the data input values, you can use the fields highlighted in the below image.&#x20;

In the dropdown, you can see the two ways of defining ranges. Click on 'Static'.&#x20;

The input field gets enabled. Enter a value as shown.

Let's define a maximum value using a measure. Select 'Measure' and '2022 Actuals' from the dropdown list. Click 'Update'.&#x20;

Enter a value that is not within the defined range. Double-click on a cell and type in the formula bar. Click 'Enter'.&#x20;

### iv) Default Value

When you create an empty series or column, the user has to enter the values manually. Instead of having those cells blank, you can display a default value. The default value can be selected from any native or formula measure as shown in the image below. If the underlying native or formula measure is updated, the default value will reflect the latest value.

#### Visual measures extrapolated for new categories <a href="#visual-measures" id="visual-measures"></a>

When you add new categories to your dataset, Inforiver automatically fills the data in the measure **based on the default value** configured while creating the measure. Let us look at an example where the default value is configured as a dimension from the dataset.

The report below has data for three regions – Central, East and West.&#x20;

Now when you add data for ‘South’ region, the report automatically fills up the Sales measure based on the default values you have configured (*Sum of Sales* dimension). You can seamlessly add new categories to your report and Inforiver will take care of populating the data. Note that this is only applicable for visual measures and not the visual columns.

## 4. Copy as data input

There might be cases where you want to create a budget for the current year based on the prior year's budget and then make finer adjustments. In such cases, Inforiver provides the 'Copy as data input' option.

Click on the column gripper corresponding to the measure you want to use as the base. Select 'Copy as data input' from the 'Insert' option. You need to be mindful that the values from the measure chosen as the source will serve as initial values. If there are changes in the source measure, these changes will not be reflected in the data input field.

A measure gets created with the same values. You can rename it and customize other properties such as row aggregation type or allow input using the side panel.

To edit values, double-click on a cell and enter as shown in the formula bar.

The values get updated and are also distributed or rolled up to the child and parent cells respectively.

In the next section, we'll be looking at [dropdown input columns](https://docs.inforiver.com/premium-table/working-with-premium-table/4.-adding-business-logic-and-formulae/insert-manual-input-columns/dropdown).
