Skip to content

Spreading

In a report or view you may want to alter the numbers as part of your process, e.g. when you are performing budgeting or forecasting. CALUMO allows you to easily and accurately achieve this by utilising the Spread functionality.

A spreading action is started by selecting a range of cells using click and drag to draw a box around the cells that you want to act on. When you do this, the additional spreading menu will appear:

Info

Spreading actions on a set of selected cells will always be applied left to right then top to bottom.

Spread Types

You will see a number of different spreading types available which are detailed in the table below.

Add To

This spread allows you to add a figure to the numbers across the range.

In this example, 10 will be added to the range selected once the tick button is selected:

You will see the figures are changed and highlighted in green:

Down by Percentage Of

This spread allows you to decrease the figures by a certain percentage.

In this example, the selected range will have 1.5% reduced from the salaries once the tick button is selected:

You will see the figures are changed and highlighted in green:

Even

This spread allows you to use a number evenly across your range.

In this example, 4 will be spread across the below range once the tick button is selected:

The values are all updated to 1 as we have 4 records to evenly spread the value of 4 across:

Percentage Of

This spread allows you to add a percentage figure across the range.

In this example, the range below will have 300% added to the numbers once the tick button is selected:

You will see the figures are updated accordingly and highlighted in green:

Proportional

This spread allows you to add a figure across the selected range proportionally.

In this example, the range selected below will evenly add 20 across the range once the tick button is selected:

You will see the figures are changed and highlighted in green:

Subtract from

This spread allows you to subtract a figure from the numbers across the range.

In this example, 1 will be removed from the range selected once the tick button is selected:

After spreading applied:

Up by Percentage Of

This spread allows you to increase the figures by a certain percentage.

In this example, the selected range will have 8.5% added to the salaries once the tick button is selected:

You will see the figures are changed and highlighted in green:

Once you are happy with the result of the spreading, you can write back these changes by selecting the Update button in the toolbar of the report or the view.

More information

The following articles have more information on spreading: