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.