MPCData formula
You can edit an MPCData formula by replacing existing formula components with supported substitutes, such as replacing a member name with a cell reference or changing members within the formula.
You can also replace an MPCData formula with another formula by specifying an Excel
formula, such as =E16+E17, in the cell. In this case, you are prompted
with a message asking if you want the formula to be written to the corresponding cell in
the dataset. Select Yes to create an MPCPushData formula that
writes the results to the dataset. Select No to create an Excel
Type 1 formula that will not write results to the dataset. You canl still lock or
constrain the cell, and any values specified over the formula will top down spread to
MPCData formulas and Excel value cells.
Note:
- If an MPCData formula
references a cell that contains a concatenating string, the string must use
this basic syntax:
=string1&string2. - If the concatenating string does not include
the
&character but uses another function to concatenate strings - such asConcatenatestring1,string2 -then the cell containing the MPCData formula will display the correct value but is no longer be writable, and cannot be locked or used for top down spreading.
You can copy and paste an MPCData formula to another cell. It retains its function based on the updated cell references.