Quick formula

Inforiver provides several one-click calculations for inserting columns and rows.

1. Quick formula

Columns/measures such as running total, % contribution to parent/grand total, etc. can be inserted in a single click. These options can be accessed from the Insert tab > Quick formula.

When you write custom formulas, you can also reference quick formula measures in them.

i) Running total

The following configuration options are available for 'Running total'.

Insert as - The running total can be inserted as a measure or column.

Based on Measure - Column/measure based on which the running total needs to be calculated.

If you want to calculate the running total for all leaf nodes, irrespective of the level of the hierarchy they belong to, select the 'Continuous Total' checkbox.

ii) Percentage running total

This formula is a variant of the running total quick formula. The running total is first calculated in the background at each level of the hierarchy, after which it is displayed as a percentage of the total/subtotal.

iii) %Growth/Decline

This option allows you to insert visual measures or a column that calculates the required percentage growth or decline of the chosen measure.

iv) % Contribution to parent

Use this option to quickly calculate each member's contribution to their parent's total value. In addition to choosing to insert as a visual measure/column and the base value, a progress bar can be enabled along with a percentage and/or value to display.

v) % Contribution to grand total

Contribution to the grand total can be inserted as shown below. To insert % contribution only for a selected category instead of all the categories or only for the column grand total, choose the 'Visual column' option and the corresponding column.

vi) Lead/lag

You can perform a lead /lag calculation to shift any trend data by 'n' periods. This helps you quickly perform downstream variance calculations such as QoQ growth, YoY growth, etc. for each period.

vii) Overall ranking

Ranks can be added across different groups in a single click. Choose to insert as a measure or column and the base measure. Note that there are no ranks applied for the subtotals.

viii) Ranking within a group

Ranks within groups can be added including ranks for subtotals as shown in the below image.

ix) Insert variance

The default variance calculated by Inforiver is based on the first measure added to the AC/PY/PL/FC fields. Insert Variance can be used to calculate the variance between any native measures, simulations, or formula fields in your report.

x) Empty Column

This option allows you to insert an empty column into the report to improve readability and visual appeal. Values cannot be entered in this column.

xi) Empty Measure

This option allows you to insert empty measures into the report to improve readability and visual appeal. Values cannot be entered in these measures.

2. Smart analysis

% contribution and variance % columns can be added in a single click based on any cell in the visual. These can be accessed in the Insert tab -> Smart analysis as shown below.

In the below image, % contribution has been added based on 2022 Actuals -> East.

In the below image, % variance has been added based on the grand total. But you can choose any other value as well. Note that the calculation gets added as a measure or column based on the presence of categories in the column field.

3. % Contribution rows

% Contribution based on any row can be inserted in a single click. To achieve this, in the Insert tab-> Insert row, select '% Contribution row'.

The % contribution row gets added as shown below.