Number

Plan allows you to enter and format numeric data in multiple ways. You can create a new empty series or copy values from another series.

In this article, you learn how to create and manage numeric data input columns.

Create a data input number column

To create a data input number column:

1. Go to Planning > Insert Column and select Number.

2. Choose one of the following options:

   • Insert a new empty series

   • Copy from another series

Create a blank number column

The Insert a new empty series option inserts a blank numeric column that you can configure and populate through manual input. After selecting this option, a side panel opens as shown below.

Enter a title and configure the required properties to create the column. For more information, see configure data input column properties.

After configuring the properties, select Create. The column is then inserted into the report.

Enter values

You can enter values in the following ways:

• Double-click a cell and enter values using the formula bar.

• Enter values directly in the cell by selecting the cell and hit enter after entering value.

Entered values are automatically aggregated to parent levels and distributed to child levels when applicable.

Create a number column from an existing series

This option creates a numeric column by copying values from an existing series.

• You can select from available measures, forecasts, or even hidden measures.

• The copied values act as initial values only.

• Changes to the source series are not reflected in the new column.

To create a numeric input column using values from an existing series:

1. Go to Planning > Insert Columns > Number

2. Select the Copy from another series option.

3. Choose the measure or column whose data you want to use.

1. After selecting the source series, a side panel opens for configuration. Update the title if required and select Create.

The column is created with pre-populated values.

Modify column properties

To modify an existing data input column:

1. Go to Planning > Insert Column > Manage Measures.

2. Select the required option:

   • Edit (pencil icon) to modify the column

   • Delete to remove the column

   • Show/Hide to control column visibility

Alternatively, you can use the column gripper:

1. Hover over the column or measure header to display the column gripper.

2. Select the column gripper and choose the required action, such as Edit Measure, Delete Measure, or Hide Column.

1. If you select Edit option, a side panel opens where you can update the required properties. After making the changes, select Update.

Create a data input column from an existing column

You can create a new data input column by copying values from an existing column.

To copy as data input:

1. Hover over the required column and select the column gripper.

2. Choose Insert > Copy as data input.

1. A side panel opens where you can update the title and configure properties if required. Select Create.

The new column is created with copied values. Changes to the source column are not reflected in the new column.