# Other operators

 Operator Description [label:] (  ) Use parenthesis to group expressions, e.g. to make ‘(2+3)*4’ equal 20. Also, by supplying a label, the expression can be used more than once in a statement without having to copy it textually.  A complex expression that you want to use several times is easier to only have to adjust in one place; -or if, in spite of the added Boolean operators, you have to use the same expression in two different branches of an ‘if-then-else’ expression. The label name can contain the letters A-Z, underscore (‘_’) and 0-9.  The first letter of the label can only be A-Z or underscore. E.g: ‘if AccumAvg:(avg(d-1,d1:0,m1)) <> 0 then sum(d-1,0,m1) % AccumAvg else 100’ if [A] then [B] else [C] Evaluates to B if A is nonzero, or to C if A is zero.
0 out of 0 found this helpful

• I have a question about: how to bulid the formula  if the result of calculation is error and I would like to change  it for zero, I mean:

If formula = error then 0 else [formula]

• Hi Beata,

Assume you have a calculation like this:

`sum(d1, 0, m1) / sum(d1, 0, m2)`

This will result in a "Math error" when the latter part is zero.

To prevent the "Math error", you can change the syntax to this:

`if sum(d1, 0, m2) = 0 then 0 else sum(d1, 0, m1) / sum(d1, 0, m2)`

BR / Ole

• Thank you. It helped ;)