The Calculated fields can be created for the following formulas. As the names of the formulas are self-explanatory, we will not go through their explanation:
- ADDHOURS
- ADDDAYS
- ADDWEEKS
- ADDMONTHS
- ADDYEARS
- SUBTRACTHOURS
- SUBTRACTDAYS
- SUBTRACTWEEKS
- SUBTRACTMONTHS
- SUBTRACTYEARS
- DIFFINDAYS
- DIFFINHOURS
- DIFFINMINUTES
- DIFFINMONTHS
- DIFFINWEEKS
- DIFFINYEARS
- CONCAT
- TRIMLEFT
- TRIMRIGHT
The following are some examples regarding when we would use the Calculated fields:
- As a requirement, we need to capture a follow-up date that should be a week after the opportunity has been created. Note that there may be more than one way of achieving the requirements, such as in this case, by creating an out-of-the-box ...