Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-03-22
Lookup Range Band

Lookup Range Band

Security:
Custom Field Management
 domain in the System functional area.
You can configure the calculated field to look up a specific value and determine where it falls in relation to a set of ranges you configure. When you use the calculated field in a report, Workday returns a single instance field corresponding to the range band that the source field falls in.
Workday optimizes report performance by indexing your calculated field so the report can run faster if you use this calculated field with an indexed:
  • Numeric field on the
    Source Field
     prompt.
  • Report data source.
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Lookup Range Band
     from the
    Function
     prompt.
  3. As you complete the
    Calculation
     tab, consider:
    Option Description
    Source Field
    Select a currency or numeric field associated with the business object as the basis for the range.
    Decimal Places
    Select a value to use with the
    From Value
     in the grid.
    Example: If you select
    2
    Decimal Places
     and enter
    50
     for the
    To Value
    , Workday automatically displays
    50.01
     as the
    From Value
     for the next row.
    Rounding
    Select a rounding method for Workday to apply in the report results:
    • Round
      : Depending on the value, Workday rounds it either down or up. Example: If you enable zero decimal places and have a value of
      1.5
      , Workday rounds up to
      2
      . If the value is
      1.4
      , Workday rounds down to
      1
      .
    • Round down
      : Rounds the value down unconditionally. Example: If you enable zero decimal places and have a value of
      1.9
      , Workday rounds down to
      1
      .
    • Round half down
      : Halves the number of decimal places in the value. Example: If you enable 4 decimal places and have a value of
      2.1234
      , Workday halves decimal places of the value to
      2.12
      .
    • Round up
      : Rounds the value up unconditionally. If you enable zero decimal places and have a value of
      1.1
      , Workday rounds it up to
      2
      .
  4. Enter values for the
    From Value
     and
    To Value
     fields.
  5. (Optional) Enter text in the
    Return Value
     field if you want to associate a phrase or word with the returned value.
You can determine where an employee's total compensation falls in relation to specified ranges.
From Value
To Value
Return Value
0
154,999
Not Highly Compensated
155,000
500,000
Highly Compensated
An employee whose total compensation is $110,000 would return a value of
Not Highly Compensated
.
Other usages:
  • Age as of a point in time.
  • Days overdue.
  • Length of service.
  • Salary increase percentage.
You can create:
  • Additional calculated fields.
  • New calculated fields from within a lookup range band calculated field.