Skip to main content
Planview Customer Success Center

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

Duration Field Type