Applying Functions to Search Results Columns

For each search results column, you have the option of applying a function to transform its data value into a format most useful for your purposes.

To apply a function to a field's values on the results page:

  1. In the Function dropdown list for a field, select the function to use:

    Function

    Description

    Field Type

    % of Total

    Calculates the percentage contributed by each record to the sum of all records in the search results.

    Numeric

    Absolute Value

    Returns the absolute value of a number.

    Numeric

    Age in Days

    Calculates the days passed since a date.

    Date

    Age in Months

    Calculates the months passed since a date.

    Date

    Age in Weeks

    Calculates the weeks passed since a date.

    Date

    Age in Years

    Calculates the years passed since a date.

    Date

    Calendar Week

    Returns the first day of the week for a date.

    Date

    Day

    Returns a full date.

    Date

    Month

    Returns the month of a date.

    Date

    Negate

    Returns the value with the opposite sign.

    Numeric

    Number as Time

    Converts the number value to hours and minutes. For example, 15.489 is converted to 15:29.

    Numeric

    Quarter

    Returns the quarter of the year for a date.

    Date

    Rank

    Returns the rank of each row when search results are ordered by column.

    Numeric

    Round

    Rounds the value to the nearest integer.

    Numeric

    Round to Hundredths

    Rounds the value to two decimal places.

    Numeric

    Round to Tenths

    Rounds the value to one decimal place.

    Numeric

    Week of Year

    Returns the week of the year for a date.

    Date

    Year

    Returns the year for a date.

    Date

  2. Click Done.

Related Topics

Search Results Display Options
Selecting Fields to Display in Search Results
Entering Custom Labels for Search Results Columns
Defining Summary Types to Roll Up Search Results
Using When Ordered By Field for Search Results
Showing Totals in Search Results
Defining Order and Overall Formatting for Search Results

General Notices