Cisco Systems CSACS3415K9 Uživatelský manuál Strana 423

  • Stažení
  • Přidat do mých příruček
  • Tisk
  • Strana
    / 678
  • Tabulka s obsahem
  • KNIHY
  • Hodnocené. / 5. Na základě hodnocení zákazníků
Zobrazit stránku 422
13-53
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Organizing Report Data
Figure 13-38 Selecting a Function
Understanding Supported Calculation Functions
Table 13-11 provides examples of the functions you can use to create calculations.
Note The Calculation dialog box does not support the use of uppercase TRUE and FALSE functions in
expressions.Calculation also does not support the use of initial capital letters for True and False. These
functions must be expressed in lowercase only.
Table 13-11 Examples of Functions
Function Description Example of use
ABS(num) Displays an absolute value for the data in a column.
ABS([TemperatureCelsius])
ADD_DAY(date,
daysToAdd)
Adds a specified number of days to a date value and
displays the result as a date value.
ADD_DAY([ClosingDate], 30)
ADD_HOUR(date,
hoursToAdd)
Adds a specified number of hours to a time value
and displays the result as a time value.
ADD_HOUR([OpenHour], 8)
ADD_MINUTE(date,
minutesToAdd)
Adds a specified number of minutes to a time value
and displays the result as a time value.
ADD_MINUTE([StartTime], 60)
ADD_MONTH(date,
monthsToAdd)
Adds a specified number of months to a date value
and displays the result as a date value.
ADD_MONTH([InitialRelease], 2)
ADD_QUARTER(date,
quartersToAdd)
Adds a specified number of quarters to a date value.
ADD_QUARTER([ForecastClosing], 2)
ADD_SECOND(date,
secondsToAdd)
Adds a specified number of seconds to a time value.
ADD_SECOND([StartTime], 30)
ADD_WEEK(date,
weeksToAdd)
Adds a specified number of weeks to a date value
and displays the result as a date value.
ADD_WEEK([askByDate], 4)
ADD_YEAR(date,
yearsToAdd)
Adds a specified number of years to a date value.
ADD_YEAR([HireDate], 5)
Zobrazit stránku 422
1 2 ... 418 419 420 421 422 423 424 425 426 427 428 ... 677 678

Komentáře k této Příručce

Žádné komentáře