QUESTION:
Is it possible to sum text fields using a MassImpact formula?
ANSWER:
Yes! You can use the toNumber formula to accomplish this.
For example:
You have 3 custom text fields in your Salesforce Org as indicated below.
- Number of Full Time Employees {FullTimeEmployee__c}
- Number of Part Time Employees {PartTimeEmployee__c}
- Total Number of Employees {TotalEmployee__c}
The formula to add the Full Time Employee field and the Part Time Employee field to be displayed in the Total Number of Employees field would look this:
- toNumber({FullTimeEmployee__c} ) +toNumber({PartTimeEmployee__c})