POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

While working with Dynamics CRM, you may come across business cases with non-linear documentation gathering processes. These processes might not fit the guided stages and steps of a Business Process Flow. An alternative is to use checkboxes that indicate whether a certain process step has been completed or that a certain document has been received. However, with multiple checkboxes it can be difficult to get a quick sense of what percentage of the process is completed. In this blog, we will discuss how to “convert” a number of checked checkboxes into a percentage value to give you an overall “percent complete” on a process. With Dynamics CRM 2015, creating these calculated fields is now a simple task!

crm-2015

1. Create a two option field for all the steps that need to be completed in the process.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

Tip: Use Save and New button to expedite this process.

2. Create as many decimal number fields as two option fields in step 1.

3. Create a decimal number calculated field that will hold the percentage value.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

4. Click edit and set the ACTION to equal the sum of the decimal fields created in step 2 as displayed below.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

5. Put all of the fields on the form.

6. Place all of the decimal number fields in a section next to the checkboxes for easy maintenance and convenience.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

7. Put the percentage field in the header.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

8. Double click on the two option fields and change their format to “Check box”.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

9. Save and publish form customizations.

10. Create a new workflow that populates hidden fields from step 2 if the related checkbox is checked and clears them out if they are not checked.

11. Set Scope to Organization.

12. Set Start when:

  • Record is created.
  • Record fields change (click Select and select all fields created in step 1.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

Tip: Use “Check Condition” step to check that checkbox is checked.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

13. Use “Update Record” to set the corresponding decimal number field to: 100/number of checkboxes

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

14. Use “Conditional Branch” and “Update Record” step to clear out the decimal field if the checkbox isn’t checked.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

15. Repeat the process for each of the fields.

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

16. Hide the section with decimal number fields on the form

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

17. Save and Publish. That’s it!

 

And here’s a screenshot of the final product!

How to “Convert” Checkboxes into a Percentage Value in 2015 Dynamics CRM

 

We see a lot of percent calculations in your future! For even more Dynamics CRM fun, check out our plethora of blogs on our main CRM Blog page.

Happy CRM’ing!

Avatar for JoeCRM

JoeCRM

Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.