Expression reserved words

Expressions are mathematical operations contained within Quiz dictionary words.

Expressions can also be added directly into the print or chart sections. In this case, they are referred to as In-line Expressions. Some reserved words are used only in expressions.

See: Quiz — Expressions for details on expressions.

   Synonyms
   Examples

 

Reserved word	Description
avg	avg ( amt1 ) count of values is kept automatically. The individual elements are kept separate for re-calculation on sub-totals and totals.  (You can’t just add up the averages on the lines for a total).
else	[ amt1 where field1= “P” else “0” ] used with in-line expressions to set alternate value.
sum	sum( amt1 * amt2 ) the sum calculation also keeps the elements separated for accumulation on sub-totals and totals.

 

  Page 1 — Quiz words
  Page 2 — Operators
  Page 3 — Where words
  Page 4 — Print words
  Page 5 — Sort words
  Page 6 — Chart words
  Page 7 — Expression words
  Page 8 — System words
  Page 9 — Global words

Next – System words >