Asked by:
How can I create a field that adds the total cost of other fields

Question
-
Help.
I'm trying to create a Total cost field for Campaign Costs that adds up a number of other fields.
For example, we have Cost of Venue, Cost of Transportation, Amount received from Partners for this campaign, etc. I need all (about 7 different fields) to be added and generate one Total Cost.
thank you
- Edited by NSackin Wednesday, September 3, 2014 12:06 AM
Wednesday, September 3, 2014 12:05 AM
All replies
-
A plugin step to update the campaign when campaign activity cost changes would be required.
Regards,
Jithesh
Wednesday, September 3, 2014 2:27 AM -
You could also use some JavaScript to add the fields together when one/any of them change:
Jason Lattimer
My Blog - Follow me on Twitter - LinkedIn- Proposed as answer by JLattimerMVP, Moderator Wednesday, September 3, 2014 2:42 AM
Wednesday, September 3, 2014 2:42 AMModerator -
If you wish the field to be available on advanced find, plugin would be your option.
Regards,
Jithesh
Wednesday, September 3, 2014 2:57 AM -
here you can find an example using plugins:
http://nycrmdev.blogspot.com/2014/08/calculated-fields-using-plugin.html
My blog: www.crmanswers.net - Rockstar 365 Profile
Wednesday, September 3, 2014 4:06 AM -
You could do this with a plugin as suggested, or use JavaScript, or use Workflows (if using CRM 2013 then a real-time or synchronous Workflow would be ideal). If you need the total calculated in front of the user as they change the other values, then JavaScript is probably the best option, but only works on forms, not if the data is updated or created in other ways (eg bulk edit, data import, workflows...)
Hope this helps.
Adam Vero, Microsoft Certified Trainer | Microsoft Community Contributor 2011
UK CRM Guru Blog- Proposed as answer by Adam Vero Monday, April 13, 2015 11:24 AM
Saturday, September 6, 2014 3:19 PM