Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


CRM 2011 Aggregates in Workflows

Posted on 2011-10-24
Medium Priority
Last Modified: 2012-05-12
In Dynamics CRM 2011 I would like to create an aggregate or sum value from values stored in a handful of fields, divide them by a fixed number, and place the result in another field.

What is the best way to accomplish this?
Question by:rdracer58
1 Comment
LVL 30

Accepted Solution

Feridun Kadir earned 2000 total points
ID: 37021112
You can perform simple math on numeric fields using dynamic values in the form assistant.

You will need one workflow step per field that you need to add to the resultant field. Select an Update record action in the workflow. In the Update record window click on the field that will receive the result and the use the increment by operator in the form assistant, and then select the first field to add to the result.

Create additional workflow steps for each field that needs to be added to the result and then one final step to multiply the field by 1/(your fixed number) (there isn't a divide action).

Hope this makes sense and helps.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question