Skip to content

Main Navigation Technical Guides

Process Functions

Set Instructions

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 Cell Style

Styles data cells against the working set with the associated style

Argument	Type	Description
Style Name	Style	The style to apply

Last updated:

Pager

Previous pageHide Set Headers

Next pageInsert Element From Title

Copyright © 2024 MODLR