Saturday, September 15, 2018

Round Off Number to the Highest Integer in Saved Search


User is using the Time Tracking feature. User created a custom field that automatically converts the time to numeric value (field name: Duration). The Duration field needs to be rounded to the highest integer number so user does not have to calculate for the minutes in excess.

For Example: If an employee worked for 4.20 hours in a day, this is to be rounded to 5.0, instead of the normal 4.20 = 4.

To accomplish this, perform the following steps:

     1. Navigate to Reports > Saved Searches > All Saved Searches > New.

     2. Select Time.

     3. In the Results tab > Columns subtab, set the following:


Summary Type


Start Time



End Time






Formula (Numeric)



Note: {customfieldxx} is the ID of the custom field.

4. Click Save & Run.

No comments:

Post a Comment