# Rearranging Tips

Last updated

Last updated

Cascading rearranged Variables

In the **previous section's** simple walkthrough, we only have three Variables, `Revenues`

, `Widgets sold`

, and `Price`

.

Most situations are more complex than this: for instance, take the example below, where `Widgets sold`

incorporates an inflation Calculation (`Widgets sold = Widgets sold [-1] * (1 + Widget sales yearly increase)`

.

We see the same warning in the `Revenues`

as previously **(1)**: we need to rearrange a child. However, this time, when we rearrange `Widgets sold`

, we see a similar warning in `Widgets sold`

, as shown below **(2)**.

Models is telling us that now we are calculating `Widgets sold`

from `Revenues`

and `Price`

, we cannot also calculate it from the inflation calculation. Therefore we must rearrange `Widget sales yearly increase`

, which can be calculated from the actual values of `Widgets sold`

in 2021 and 2022.

This results in the below output with `Widget sales yearly increase`

also rearranged **(3)**.

In this way, rearranged Variables cascade down to the "bottom" of the Model, or the point at which there are no more Calculations to rearrange.

Reversing relationships

Models allows you to quickly change the direction of calculation flows if you change the desired output of a Model.

Take the below example, where we have set our Model up with `Revenue`

as the output from the two input Variables, `Widgets sold`

and `Price`

.

If we select both **(1)** the `Revenues`

Variable, and one of its child Variables (in the example above, `Widgets sold`

), we are offered the option to reverse their relationship, using the **Reverse relationship** button **(2)**.

This results in the below:

`Widgets sold`

has been converted to a Calculation Variable with Calculation `Revenues / Price`

**(3)**. `Revenues`

has been converted to an Assumptions Variable where the second Time Segment is now rearranged **(4)** to its original Calculation of `Price * Widgets sold`

.