Skip to content

Main Navigation Technical

Modelling Guides

Process Functions

Set Instructions

PowerPoint Addin

Sidebar Navigation

Set Instructions

Set Formatting

Add Blank Space

Collapse Next Instruction

Enable Drill Down

Expand

Expand All

Expand Next Instruction

Indent

Reset Indents

Reverse (Subtotals At The Bottom)

Set Default Using The Next Instruction

Set Manipulation

Group By Value Using The Next Instruction (Ascending)

Group By Value Using The Next Instruction (Descending)

Remove Consolidations

Remove Items Using The Next Instruction

Sort By Name (Ascending)

Sort By Name (Descending)

Sort By Value Using The Next Instruction (Ascending)

Sort By Value Using The Next Instruction (Descending)

Data Formatting

Format 0%

Format 0,000

Format 0,000.0

Format 0,000.00

Format 0,000.000

Format 0,000.0000

Format 0,000.00000

Format 0.0%

Format 0.00%

Format 0.000%

Format Items Using The Next Instruction

Ignore New Formatting On Prior Members

Advanced Functions

Apply Header Sizing Using Formula

Apply New Header Labels Using Formula

Apply Number Formatting Using Formula

Apply Style Using Formula

Disable Input On Cells

Hide Dimension Headers

Hide Set Headers

Insert Cell Style

Insert Element From Title

Insert Heading Style

Insert The Next Element From A Hierarchy

Insert The Previous Element From A Hierarchy

Insert Using Formula

Inserts A Variable Value Into The Working Set

Override A Set Element Using Formula

Set The Alias For The Set

Suppress Empty Elements (Except One)

Suppress Zeros

Variance % Using Prior Two Members

Variance % Using Prior Two Members (Reversed)

Variance Using Prior Two Members

Variance Using Prior Two Members (Reversed)

Sequential Functions

Time Functions

Insert Using Formula

Inserts a an element into the working set using a formula

Argument	Type	Description
Formula	Formula	The formula to evaluate for each element in the working set

Last updated:

Pager

Previous pageInsert The Previous Element From A Hierarchy

Next pageInserts A Variable Value Into The Working Set

Copyright © 2025 MODLR