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.
(missing or bad snippet)