1. Calculation functions
  2. Functions
  3. Common Formula Errors

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.