AX2165

Change calc method rules

End users can replace an existing calc method in the sheet by applying a new calc method, thereby changing the calculations used on the row (or rows). See Changing rows in a plan file.

The following replacement rules apply when using the Change Calc Method feature. When creating calc methods, keep these rules in mind so that change operations will work as desired.

The change operation is evaluated on a cell by cell basis. Actions depend on what the new calc method (the calc method replacing the existing calc method) contains in each cell.

If the new calc method contains:	The following action occurs:
A value or a string	The value or string in the new calc method is ignored, and the existing cell value is retained as follows: If the existing calc method contains a value, a string, or is blank, then the existing cell contents are retained as is. If the existing calc method contains a formula, the value resulting from the formula is retained by using Paste Special – Values. The formula is removed.
Formula	The formula in the new calc method overrides the existing cell contents.
Empty cell	The empty cell in the new calc method overrides the existing cell contents.

NOTE: The normal change rules do not apply to calc method variables. If the new calc method has a variable defined, the variable value specified by the user always overrides the existing cell contents. However, if the user does not specify a variable value (if the variable is not required and the user leaves the entry blank, or if the variable is excluded from the change operation because it is set to Insert Only), then the normal change rules apply to that cell.