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

FormType based Business Rules in CRM 2015

Ever been in a situation where you need to write a JavaScript code to show/hide, Enable/Disable or set certain field on the form, am sure there were a lot. The dev’s at Microsoft eased up this task by introducing the concept of Business Rules, but did you ever wondered what if all this needs to be done based on the form type?

Let’s say you want to show certain field if the FormType is Create or Update, unfortunately the first thing that will come to mind is that this cannot be achieved using Business Rules.

Today I’m going to show you a little/neat trick which will allow you to do this without writing a single piece of JavaScript code.
Continue reading