Skip to content

MODLR

Main Navigation Technical Guides

Cube Functions

Process Functions

Set Instructions

Excel 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

Variance % Using Prior Two Members (Reversed)

Creates a variance between the last two elements in the working set

Last updated:

Pager

Previous pageVariance % Using Prior Two Members

Next pageVariance Using Prior Two Members

Variance % Using Prior Two Members (Reversed) ​

Variance % Using Prior Two Members (Reversed)