Floor Function
Floor (number as Numeric) as Numeric
Category: | Math |
Description: | Rounds a number down towards zero to the nearest integer |
Supported Context: | FormulaField And BusinessRules |
Parameters: | |
number as Numeric | Numeric value or reference to a numeric field |
Returned value as Numeric | Returns a numeric value equal to the number specified in the "number" parameter rounded down towards zero to the nearest integer |
Example #1 |
Create a Custom Field using the Duration Field Type that will return the total hours spent on a work item rounded down to the nearest integer. Hours(Floor($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. Example: $C_value = 5.4, Floor($C_value) > returns 5 Example: $C_value = 99.9999, Floor($C_value) > returns 999 |
Tips | Create workflow rules to set standard field values via formulas |
Additional Links |