Complex Calculations in Business Rules Dynamics CRM

Business Rules have been one of the greatest additions in Dynamics CRM, I just personally love them. Lately, there was a lot of feedback as to complex calculations were not possible using them.
I had a simple requirement where we just needed to do a very simple Percentage Calculation I.e. ProbableValue = (Est. Revenue * Probability) / 100. Previously this was being done in the JavaScript.

The idea to do this calculation in Business Rule is to divide the equation into multiple parts with each part containing only single operation, my case looks like below

**Probable Value = Est. Revenue * Probability**
**Probable Value = Probable Value / 100**

Hope you get the idea. This is how you should break your calculations and have only one operation per statement. It will also enable you to do any complex calculations as well. Possibilities are endless 🙂

See my Business Rule below

Export Translations

Clear field value in Business Rule CRM 2015 Update 1

With the introduction of Business Rules in CRM, it is now very easy for end users (non-developers) to perform simple tasks like Set value, show/hide field, etc based on conditions without writing any code. Previously these simple tasks were performed by developers using JavaScript.

Having said that, Business Rules also came with some limitations, one such limitation is the inability to clear field value. Lots of feedback’s were provided and finally the developers have listened and they have introduced this functionality in the latest update i.e. CRM 2015 Update 1.
Continue reading