Skip to main content
Planview Customer Success Center

Ceil Function

Ceil (number as Numeric) as Numeric

Category: Math
Description: Rounds a number up to the nearest whole integer
Supported Context: FormulaField And BusinessRules
Parameters:  
number as Numeric Positive or negative numeric value or reference to a numeric field
Returned value as Numeric Returns a numeric value equal to the entered number value rounded to the nearest whole integer
Example #1

Create a Custom Field using the Duration Field Type that will return the total hours spent on a work item rounded up to the nearest whole integer.

Hours(Ceil($ActualEffort/Hours(1)))

$ActualEffort\Hours(1) is used to normalize the actual effort in amount of hours (regardless of whether the effort was entered in days, weeks, etc). The Hours() function is then used to convert the effort back to the duration field.

Tips Create workflow rules to set standard field values via formulas
Additional Links

Duration Field Type