Modify the options for formulas within a workbook.
| Option | Description |
| Replace null values | Replaces null values with the contents of the field Replace null values with. |
| Validate members | When parsing a member, the formula will check that a valid member has been selected |
| Remove drill indicators | Don't display the indicator that row/column can be drilled |
| Remove nulls when drilling | If there are any blank rows/columns when drilling down on a member, they'll be removed so that there are no empty rows/columns in the report. |
| Remove 0 values when drilling | If there are any rows/columns when drilling down on a member that only contain zeros, they'll be removed so that there are no zero rows/columns in the report. |
| Resize Columns after drilling | This allows a cell to resize itself when a formula is inserted to display the result correctly. |
| Indent drilled members | When the user drills down on a member, they'll be displayed as indented. |
| Lighten background colour on drill | When the user drills on a member, a slightly lighter version of its background color will be used for the new members |
