There are a number of other functions that can be used in Cubix rules:
| Syntax | Description |
|---|---|
| ; | Comment indicator. Any text after the comment will not be interpreted as part of the rule. Use this to include comments explaining complex rules. |
| Round(N1,N2) | Round N1 to N2 decimal places |
| @CAP | Returns the index number of the Current Actual Period (CAP). Only available in Actual and ActFor versions |
| @Input | Sets the cell to allow input |
| @NA | Returns a blank cell |
| @CurCCR | Returns the current currency rate |
| [-1] | Relative member. Returns the value of the member according to the relative index number. i.e. Product[-1] returns the value from the product one position earlier in the list. |
| Time[:-1] | Relative time period, using the opening balance (if available) |
| Time[>-1] | Relative time period, ignoring the opening balance |
| Time[:>-1] | Relative time period, using the opening balance as a logical time period |
Post your comment on this topic.