Articles on: Customers & quotations
This article is also available in:

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.


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. All signs and functions are in Symbols and formulas you can use in posts.

Updated on: 18/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!