Skip to content

MODLR

Main Navigation Documentation

Modelling Guides

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

Formula-Driven

Apply Header Sizing Using Formula

Apply New Header Labels Using Formula

Apply Number Formatting Using Formula

Apply Style Using Formula

Insert Using Formula

Override A Set Element Using Formula

Headers & Styling

Disable Input On Cells

Hide Dimension Headers

Hide Set Headers

Insert Cell Style

Insert Heading Style

Set The Alias For The Set

Element Insertion

Insert Element From Title

Insert The Next Element From A Hierarchy

Insert The Previous Element From A Hierarchy

Inserts A Variable Value Into The Working Set

Variance

Variance % Using Prior Two Members

Variance % Using Prior Two Members (Reversed)

Variance Using Prior Two Members

Variance Using Prior Two Members (Reversed)

Suppression

Suppress Empty Elements (Except One)

Suppress Zeros

Sequential Functions

Time Functions

Are you an LLM? You can read better optimized documentation at /set-instructions/set-manipulation.md for this page in Markdown format

Set Manipulation

Last updated:

Pager

Previous pageSet Default Using The Next Instruction

Next pageGroup By Value Using The Next Instruction (Ascending)

Set Manipulation ​

Set Manipulation