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.
Paintcolouris not the same aspaintcolour. - 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^3gives 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.000is 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.
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)orSUM(a)+SUM(b)in one parameter does not work.
You can find a worked-out example with SUM in Examples of posts and formulas. All signs and functions are in Symbols and formulas you can use in posts.
Updated on: 18/11/2026
Thank you!
