Skip to main content

 

Planview Customer Success Center

Truncate Function

Truncate (number as Numeric) as Numeric

Category: Math
Description: Returns the y integer part of floating-point number, for example Truncate(32.7865) will return 32
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 whole number of value of the number indicated in the "number" parameter, trimming all numbers after the decimal point
Example #1

Build a workflow rule that sends an email with an update of progress. Create the following formula within the body or subject of the email

Truncate($PercentComplete)

Tips Other similar functions include Ceil(), Floor(), Round()
Related Functions

Ceil()

Floor()

Round()