Adding a cross-dimensional reference
To add a cross-dimensional reference:
- Open the Formula Builder page.
- Select a schedule line.
- Select a line type.
- Place the cursor in the formula at the position where you want to insert the reference and click Of.
- Tab to <dimension>.
- In the Dimension list, double-click a dimension to insert it into the formula. Or, you can specify the dimension name.
- Continue pressing Tab to complete the other dimension and members selections for the formula. You can specify relative offsets for period and year dimension members. A relative offset is an integer that specifies a member relative to the one currently being processed. Only backward references are allowed.
- Click .
- Select .
- Click .