Quick formula

The Inforiver Premium table has several one-click calculation options for inserting columns and rows.

1. Quick formula

Columns/measures such as running total, percentage contribution to grand total, percent growth or decline, and so on can be added with a single click. These options can be accessed via Insert > Quick Formula.

The Inforiver Premium Table does not include these time intelligence-based formulas, such as Running Total, % Running Total, and Lead/Lag. They are available on the Inforiver Reporting and Writeback Matrix.

1.1. % Growth/Decline

This option allows you to include visual columns that calculate the required percentage growth or decline for the chosen measure.

Click on Quick Formula > % Growth/Decline

1.2. % Contribution to grand total

Similar to the above, the percentage contribution of each row to the grand total can be entered, as shown below. There are additional options, such as including the percentage contribution using bar charts and displaying them in a specific color.

1.3. Overall ranking

Adding ranks to multiple rows only requires one click. To insert a rank column, select the base measure that will be used to rank the rows.

1.4. Insert variance

The default variance calculated by the Premium Table 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.

When creating formula columns, these quick formula measures can also be referred to, similar to data input or native columns.

2. % Contribution rows

With a single click, you can insert the percentage contribution of any row with regard to the grand total. To achieve this, in the Insert > Insert row, select % Contribution row.

Select a row to enable the 'Insert row' option.

The % contribution row gets added as shown below.

PreviousEditing cells NextManage inserted rows

Last updated 11 days ago