CONTINUE

Multiple formulas can apply to the same cell on a Cube. When a cell is calculated, MODLR works through those formulas in the order they appear in the cube's Formula List, stopping at the first one that produces a value - this is the formula stack. That order is whatever the Formula List is currently set to, drag-and-drop reorderable.

CONTINUE tells the engine to stop evaluating the current formula and move on to the next one in the stack. If no further formula applies, any manually entered (static) value for that cell is returned instead. If there's no static value either, the cell is empty.

CONTINUE

CONTINUE has no Excel equivalent, because Excel formulas don't have a stack to fall through. It can appear anywhere in a formula, including inside an IF() branch.

CONTINUE versus STET

STET looks similar but behaves differently: STET stops the entire formula stack for the cell and jumps straight to the static value, skipping every remaining formula. CONTINUE only skips the current formula - the engine still tries the next formula in the stack, which might go on to calculate a value of its own rather than falling through to a static one.

If a Cube only has a single formula applying to a cell, there's no difference between the two, since there's no "next formula" for them to differ on.

Common pattern: letting a later formula have a turn

CONTINUE is useful when a formula should step aside for a specific case, but a different formula further down the stack (or the cell's static value, if nothing else applies) should be allowed to take over:

IF(ISLEAF(), CONTINUE, CONSOLIDATEAVERAGE("Time"))

This pattern lets a formula fall through to the cube's normal roll-up behaviour at leaf cells, applying its own consolidation logic only higher up. Compare this to the HASSTATICVALUE() override pattern documented on STET, where the intent is to stop the whole stack rather than defer to whatever's next in line.

TIP

If CONTINUE is reached and there's no further formula in the stack and no static value either, the cell simply returns empty - this is correct behaviour, but can look like a missing formula if you were expecting a calculated result. Check whether a subsequent formula or a static value actually exists at that cell.