Other operators



[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.

Was this article helpful?
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 ;)


Please sign in to leave a comment.