> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.robaws.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Why does the formula in my post give an error or a wrong result?

If a formula in a post is not right, Robaws shows a message with the name of the parameter, or you get a result you do not expect. Go through these points.

## The formula gives an error

* **Name of the parameter**: parameter names are case-sensitive. `Paintcolour` is not the same as `paintcolour`.
* **Text values**: always put text between double quotes, for example `paintcolour == "blue"`.
* **Values in a function**: separate them with a semicolon, for example `Math.max(2;6)`.
* **Two parameters that refer to each other**: if parameter A refers to B and B refers to A, Robaws cannot calculate anything. You then get the message *Cycle detected between A and B*. Leave one of the two parameters without a reference to the other.

## The result is not right

* **Exponentiation**: use `Math.pow(x;y)`. The `^` sign does not work as a power in posts: `2^3` gives 1 instead of 8.
* **Decimal numbers**: write a decimal number with a comma, for example `2,4`, and do not use a point for thousands. `1.000` is 1 for Robaws, not a thousand.
* **Rounding**: if you round in a formula to more decimals than you show, increase **Amount #decimals** in the [general settings](https://support.robaws.com/en/article/setting-the-number-of-decimals-1d04c2d/).

## SUM does not work

With `SUM(name)` you add up the values of a parameter across all posts of a quotation. Keep in mind:

* You only use SUM in a **quotation parameter**, on the **Parameters** tab of the quotation or the quotation template. In a post you get the message *Aggregation parameters are only allowed in a global parameter*.
* Write `SUM(name)` in capitals and without a space before the bracket.
* Put SUM on its own in the parameter, without calculating further with it. Do you want to round or add up the sum? Then create a second parameter that refers to the first one. `Math.ceil(SUM(workhours)/8)` or `SUM(a)+SUM(b)` in one parameter does not work.

You can find a worked-out example with SUM in [Examples of posts and formulas](https://support.robaws.com/en/article/examples-of-posts-and-formulas-17lcfwl/). All signs and functions are in [Symbols and formulas you can use in posts](https://support.robaws.com/en/article/symbols-and-formulas-you-can-use-in-posts-3uv9mx/).