Special variables
Several special variables that access specific data and that are denoted by key words inside curly brackets are available. These are not case sensitive, but cannot have extra internal spaces. To avoid typographical errors, it is recommended that they be built using the Expression Builder. The special variables are listed in the table below.
| Special Variable | Description |
|---|---|
| {BaseData} |
Substitute the value in the base data column. |
| {ColCode} | Substitute the code of the current column. |
| {FieldCode} | Substitute the corresponding row value. |
| {ModelBranchName} | Substitute the name of the current active branch. |
| {ModelBranchDesc} | Substitute the description of the current active branch. |
| {PageName} | Substitute the name of the current spreadsheet page. |
| {ParentDesc} |
Substitute the description for the parent sheet. |
| {ParentName} | Substitute the name for the parent sheet. |
| {ParentPath} | Substitute the path for the parent sheet. |
| {PLast} | Substitute the last period number. |
| {PName} | Substitute the name of the current period. |
| {PNO} | Substitute the current period number. |
| {PPrev} | Substitute the value in the previous period. |
| {RowCode} | Substitute the code of the current row. |
| {RowCodeEnd} | Take the last part of a row code after the last underscore. |
| {RowCodeEx} | Substitute the code of the current row including the expandable row index. |
| {RowCodeEndEx} | Take the last part of a row code after the last underscore including the expandable row index. |
| {RowCodeIndex} | Substitute the index number from the expandable row code. |
| {RowCodeMid} | Take the middle part of a row code after an underscore. |
| {RowCodeStub} | Take the first part of a row code before an underscore. |
| {RowDesc} | Substitute with current row description. |
| {RowUnits} | Row units of the current row. |
| {ScheduleName} | Substitute the name of the active schedule. |
| {SheetDesc} | Substitute the sheet description. |
| {SheetName} | Substitute the sheet name. |
| {SheetPath} | Substitute the sheet path. |
| {StructureName} | Get the name of the structure. |
| {StructureRef} | Get the reference of the structure. |
| {SubTPLast} | Get the last period of subtotal. |
| {SubTPStart} | Get the start period of subtotal. |