The npv() function provides the ability to calculate the Net Present Value of an investment.
Syntax
npv(rate, value1, [value2]…)
| Argument | Description |
| rate
(required) |
The discount rate over one period. An expression that results in a numeric value (i.e., a hard-coded number, a reference to a numeric attribute, or an expression that returns a numeric value). |
| value1
(required) |
The first value representing cash flows. An expression that results in a numeric value (i.e., a hard-coded number, a reference to a numeric attribute, or an expression that returns a numeric value). |
| value2
(optional) |
The additional values representing cash flows. |
Where Available
Available in all places the expression or injected expression icon is visible, as well as within Filter fields on Cards, Tables and List/View sections.
Examples
| Where | Example(s) |
| Business rules: Set Value
Attribute expression |
npv(Discount_Rate__c, Monthly_Cash_Flow__c)
|
| Field Editability expression
Tab Visibility expression Business rules: Condition |
npv(Discount_Rate__c, Monthly_Cash_Flow__c) > Target_NPV__c |
| Business rules: Notification Subject
Business rules: Notification Body Dynamic Filter |
{!npv(Discount_Rate__c, 2022_Return__c, 2023_Return__c, 2024_Return__c, 2025_Return__c)} |
| Metric expression | npv(Interest__c, Year_1__c, Year_2__c, Year_3__c, Year_4__c, Year_5__c) + Initial_Investment_Amount__c |