Quick formula
Last updated
Was this helpful?
Reporting & Writeback Matrix Docs
Last updated
Was this helpful?
Inforiver provides several one-click calculations for inserting columns and rows.
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.
The following configuration options are available for 'Running total'.
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.
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.
This option allows you to insert visual measures or a column that calculates the required percentage growth or decline of the chosen measure.
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.
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.
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.
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.
Ranks within groups can be added including ranks for subtotals as shown in the below image.
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.
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.
This option allows you to insert empty measures into the report to improve readability and visual appeal. Values cannot be entered in these measures.
% 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.
% 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.
Insert as - The running total can be inserted as a .
