Lucent Technologies CentreVu Report Designer, Руководство пользователя

Страница: 232 / 266

SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics
18-10
Using constants makes sense only if you have a fixed value that you
want to use under one or both of the following conditions:
●
The constant is a value that you will use in a number of different
custom reports (for example, an average wage rate).
●
You would not be able to remember the numerical value, but could
remember a name assigned to the value (for example, for the $9.00
hourly wage rate for an agent called Smith, you could have a
constant called
Smithwage
.)
The
CentreVu CMS real-time database allows only whole numbers in
queries. If you need a value to be a decimal (for example, 9.5), use whole
numbers and division to arrive at the correct number (so, in order to have
9.5 in a query, you would use 19/2 as the query entry).
Calculations
18
A calculation is a combination of database items and arithmetic
operators. You can also include constants in a calculation. The arithmetic
operators are as follows:
Some examples of calculations are:
dsplit.ACDCALLS/dsplit.ACDTIME
hagent.AUXhagent.ACWOUTTIME
100*((cagent.I_cagent.I_ACWTIME)/
cagent.I_STAFFTIME)
Arithmetic operations are generally performed in order from left to right.
However, multiplication and division operations are performed before
addition and subtraction operations, unless the addition or subtraction
operations are enclosed in parentheses. Operations in parentheses are
always performed first. If more than one set of parentheses is used, the
operation in the set farthest to the left is performed first. If one set of
parentheses is inside of another set, the operation of the inner set is
performed first.
+ add
- subtract
* multiply
/ divide
( ) perform first