Number
Numeric data can be entered and formatted in a variety of ways. You can insert a new empty series, copy from another series, perform an advanced copy, or import from a file.
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, Import from file, and Import from Infobridge(Writeback Matrix only). Let's go through each of these methods.

1.1. Insert a new empty series
If you select this option, a visual measure gets inserted as shown below. Use the options in the Data Input side pane, such as aggregation type, min/max value, etc to customize the data input field.

Change the title and let's stick with the default settings for the other properties. Click Create.

To learn to enter a value in an empty numeric column in the Enter a value section.
1.2. Copy from another series
Selecting this option opens a sub-menu listing all measures and forecasts in the report. Choose a series to create a numeric column populated with values copied from the selected series. These values are used only as initial defaults. Any subsequent changes to the source measure are not reflected in the data input field.

A visual measure gets inserted as shown below. For now, let's change the title and go with the default settings for the other properties. Click Create.

The newly created numeric measure will be pre-populated with the data of the chosen series.
In the image, a numeric measure is created by copying data from Sales, and the new measure is populated with the copied data.

1.3. Advanced Copy
When you select this option, a pop-up window opens where you can create measures for multiple time frames and populate them with various series and configurations.
You can also choose this option to fill in the blank forecast measures if you have already inserted them in your report.

The image below demonstrates the possible configurations (copy methods) you can set for each time frame of the measure. Let us look at the options available in detail.

Column: Define the end period for the column here. You will be provided with the +Add new option beside the Column Selection if the end period chosen is not the last one in the report. You can create multiple columns by selecting different end periods for each column.
Source Series: This dropdown lists the available native /data input /forecast series from which you can choose the required one to be copied. Choose 'Blank' to leave the measures empty.
Copy Method: Here, you can select the copy method based on which the column is populated.
Period Range: Copies the data from a range of periods to the column, period-wise.
Single Period: A single period's data is copied to all the periods of the column.
Average of Period Range: The average of the data range is calculated and spread to the column periods.
Column Selection: This option lets you select a single period or a range of periods from the source series, based on the copy method chosen.
After setting up all the details, click Create. The image below is a screengrab of the result of the above configuration.

1.4. 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.

Click Preview.

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

1.5. Import from Infobridge
With Infobridge, you can import measures from another Inforiver report. Let's say we have a Sales report and we need to import the Margin measure from a margin report. In scenarios where we need to consolidate data across Inforiver reports, we can publish the report to Infobridge and import measures into another report. Learn more about Infobridge.
Coming back to the sales report example, click on the Import from Infobridge option. Create a mapping in the Infobridge Measure side pane to import the Margin field.

After you click Create, notice how the Margin field has been inserted. Learn more about inserting Infobridge measures.

2. Enter a value
To enter a value, double-click a cell and type in the formula bar that opens at the top. You can double-click to enter values in any cell.
The entered value is captured and automatically rolled up to the parent and, where applicable, distributed to the child nodes.

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 edit icon as highlighted.

We have already discussed an overview of the properties in the introduction. In this section, we'll look at properties that are specific to numeric data inputs.
3.1. Row aggregation type
Row aggregation type defines the aggregation method to be applied for the total and sub-total rows. By default, the subtotal and total rows are calculated as the sum of the child rows, as can be seen in the image.

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

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

3.2. Column aggregation type
When you enable totals and subtotals, the child column values are summed up to populate the parent values. In this example, the budget for each month is summed up to populate the quarterly subtotal and overall budget. The column aggregation is set to sum by default for numeric data inputs.

You'll see the column totals and subtotals change based on the selected column aggregation type. A few examples are shown here.


Learn more about managing aggregation.
3.3. 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.
In the image below, 220m entered in the subtotal has been distributed equally to the subregions.

There are several other ways to distribute values which are covered in Budgeting & allocations.
This distribution can be disabled if not required for certain scenarios. Uncheck the Distribute parent value to children checkbox.

3.3. 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.

In the dropdown, you can see the two ways of defining ranges. Select Static.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.

Let's see this in action by entering a value that is not within the defined range. Double-click on a cell and type in the formula bar. Click Enter.

You will see an error message that shows the allowed range for this particular cell. The maximum is 82m, as that is the value of 2022 Actuals.

Values within the defined range are captured as shown in the below image.

3.4. 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.

4. Auto-populate visual measures for new categories
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.

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.

Last updated
Was this helpful?