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 |