Formula Operators and Syntax

See Also...  

Statement Analyzer formulas follow the standard mathematical order of operations and use standard operators and syntax.

Note: You can annualize formulas and define the precision (number of decimal points) on the same screen that you use for defining the formula. For more information, see the topics that relate to where you're entering the formula.

Operator / Syntax

What It Does

+  -  /  *  (  )

Function as standard mathematical operators

x^y

Raises x to the power of y (carat symbol, on the 6 key).

(subtotal/total) * 100

Create percentage by dividing a subtotal by the appropriate total and then multiplying by 100

*365

Used for Age or Days ratios

ABS(x)

ABS(x) = x if x>0

ABS(x) = -x if x<0

Takes the absolute value of x. Note that the value to make absolute must be enclosed in parentheses

@IF (x,y,z)

Use the following operators with the preceding expression:

>  <  >=  <=  =  !=

If x is true, then the result is y.

If x is not true, the result is z.

The commas take the place of the words “then” and “else.”

The expression must be in parentheses.

: (colon)

Sum of range of consecutive values.

Note: To use the colon for a range of values, the value lines must be consecutive, and the value variables must all have the same first letter (indicating data type and/or location) or the same second letter (indicating period), as explained in the data identification topic.

Also note that on the Covenants screen, this operator cannot be used with additional data lines (the Z expressions). But it can be used with statement lines.