The formula recalculation function is used to restart the calculation of a formula over a given period of time.

Prerequisite : you must have a functional admin role to access the Formulas module

Log in to Io-base and click the button at the top right of your screen, highlighted below :

The Io-base administration page opens.

Go to the Referentials/Formulas management menu.

In the Actions column, click on the "Add recalculation" button.

A pop-up window opens. It will allow you to enter the beginning and the ending dates of your recalculation.

The recalculation will generate new values for the period you specify. However, the new values will NOT replace the old ones.

To confirm, check the "I wish to continue" box and click on Create.

Note : In order for the recalculation to be operated, the selected formulas must contain metrics.

For instance, if the expression of a formula is "rand()+3", the recalculation is not possible.

It becomes possible if you add a metric to the expression.

You can check the progress and history of your formula recalculation by clicking on the button at the top right.

Once the recalculation is complete, you can view the result with Indaba Explorer.