| Maximum allowed value |
The dimensions table won’t support values equal to or greater than 1.000.000 (one million). |
| Formatting errors |
Color codes make the formulas easier to scan. All formatting errors will be highlighted with a red dotted line. By hovering over the highlighted term, you’ll be able to see a description of the issue in a tooltip. All formatting errors must be fixed before committing the changes. |
| Circular Reference - (The field depends on itself) |
To prevent this scenario, the current field will not show the option in the autofill menu, and it will not be seen as a potential term. |
| Circular reference - (Using a field that is computed by the value of this calculation) |
The field will be disabled in the autofill dropdown and a tooltip message will inform you that a circular dependency will be created. |
| Combining Preset Formulas with Fields, Functions, Numbers, or Operators |
To prevent you from using presets in formulas, the cell editing will close after selecting a preset. |
| Case sensitiveness |
The formula builder is not case-sensitive. |
| Special characters |
When written manually, the fields containing special characters must be wrapped in quotation marks. e.g., “field name”. You can also search and select the option from the dropdown. It will automatically apply the quotation marks. |
