A new knowledge base article has been published on our support portal.
Scenario Overview
In this business scenario we need to update open Opportunities on a daily basis to set a Remaining Business Days field. This provides useful information for reporting.
The solution is achieved by a formula combined with a daily Entity Update Schedule. The formula updates the Remaining Business Days field when the Estimate Close Date field changes. The schedule targets all open Opportunities and updates the Estimated Close field to its same value which then triggers the Formula to recalculate the date.
N52 Formula Manager Solution
The Formula Manager solution works like this:
- A formula of type Save – Perform Action is created on the Opportunity entity
- When the Estimate Close Date changes the formula calculates the remaining business days using the DiffWorkingDays function
- The formula then updates the Remaining Business Days field with the result of the calculation