Common Formula Errors - Anaplan Technical Documentation

Problems entering formulae

Quotes around my list or module names are removed after I have typed them and pressed Enter.

List or module names containing numbers or the full point are enclosed in single quotes to delimit the name. If the item is recognized, encapsulating quotes are removed.
Note that if both the module name and the list item contain numbers or a full point, each individual item must be encapsulated. For example, a module named Sales 2017, with a line item named Region 3 would be referred to as 'Sales2017'.'Region 3' in a formula.

When entering a formula I see a message telling me of a formula clash

If you:

enter an individual line item formula, and try to enter a module scope version formula that also applies to the line item OR
have a module scope version formula applied to a line item, and try to enter an individual line item formula also for the line item; OR
have module scope version formulas, and you try to enter a version formula for the entire model that clashes with an existing module scope version formula; OR
have version formulas for the entire model, and try to enter a module scope version formula that clashes with a version formula for the entire model;

you will be blocked—a message appears telling you of the formula clash.

For information on precedence and setting the scope of formulas, see Formula Editing.

Unexpected results using a version formula

The version formula for the entire model takes precedence over module scope version formula

For information on precedence and setting the scope of formulas, see Formula Editing.

Some common problems associated with particular functions

Function	Problem	Solution
QUARTERVALUE	Summary value is three times what I expect	Check the result line item Time Scale in the result module Blueprint matches the Time Scale in the source module.
TIMESUM	Aggregate TIMESUM formula does not work as expected	The TIMESUM function remains well-formed with a single Aggregate parameter, which is mandatory. However, missing intermediate parameters are not permitted.
MOVINGSUM	Formula does not work as expected	MOVINGSUM requires the result to have a time dimension as it's used for moving sums and moving averages that vary over time. Use TIMESUM for modules with no Time dimension
TIMESUM	My To and From values are not working as expected	The only compulsory parameter is the line item you're aggregating. If both From and To parameters are omitted, all periods are added If To is omitted, the period defined in the From parameter is returned If the Aggregate parameter is omitted, default to SUM
WEEKVALUE	The value returned for the Week summary is incorrect	Make sure that the Blueprint Time Summary method for result line items gives the summary you want.