Defining the Data for a Custom Report
CentreVu CMS Custom Reports
Defining Report Fields
4-16
Calculations
4
A calculation is a combination of database items and arithmetic operators.
You can also include constants in a calculation. The arithmetic operators are:
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.
Calculation
names
4
A calculation name is a name, as defined in the Dictionary subsystem, that
can substitute for the actual calculation. The calculation name can be a
standard name (used in standard reports) or a name you define. You cannot
append a table name to a calculation name. Therefore, you must specify a
table name in the
Table for calculations
field.
A calculation name normally reflects the purpose of the calculation. As a
result, entering a name is an easier, more meaningful way to define data for a
report field. More importantly, if you use a calculation name in many custom
reports and later decide to change the calculation, you can simply make your
changes once in the Dictionary subsystem.
CentreVu CMS then applies
those changes to every report that uses the calculation name.
For example, if you use the standard calculation name
<PERCENT_ACD_TIME>, which represents the calculation
+
add
-
subtract
*
multiply
/
divide
()
perform first
Note
CentreVu CMS differentiates between uppercase and lowercase
letters in calculation names. Therefore, be sure you enter the desired
calculation name
exactly as it appears in the Dictionary subsystem.
Summary of Contents for CentreVu
Page 16: ...Preface CentreVu CMS R3V5 Custom Reports Related Documents P 10 ...
Page 44: ...Getting Started CentreVu CMS Custom Reports Deleting a Custom Report 2 10 ...
Page 140: ...Completing Your Custom Report CentreVu CMS Custom Reports Running Custom Reports 5 22 ...
Page 178: ...Database Items and Calculations CentreVu CMS Custom Reports General Information A 2 ...
Page 188: ...Glossary CentreVu CMS Custom Reports GL 10 ...
Page 198: ......