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 |