Skip to main content
Planview Customer Success Center

Exp Function

Exp (number as Numeric) as Numeric

Category: Math
Description: Returns e raised to the power of the given number
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 e raised to the power of the number given in the "number" parameter
Example #1

Create a Custom Field using the Duration Field Type that will return the exponential value of the total hours spent on a work item.

Hours(Exp($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 Functions can be used within other functions to create more complex formulas
Additional Links Duration Field Type