Assignment statements

Assignment statements link a schedule line to the result of an algebraic expression. For example:

[Net Sales] = [Gross Sales] - ([Cost of Sales] + [COGS]);

Algebraic expressions can contain:

• Constants.
• Line references (a schedule line name enclosed in square braces [ ]).
• Addition (+), subtraction (-), multiplication (*), and division (/) operators.
• Line names, including lines from other schedules.
• Cross-dimensional references to members of other dimensions.
• Semi-colons (;) at the end of each assignment.
• Parentheses as needed to override the default precedence of multiplication and division operators:

  [Gross Profit Margin] = ([Sales] - [Cost of Sales]) / [Net Revenue];