web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :

Dynamics Tip: Using business rules to sum up more than two fields

ashlega Profile Picture ashlega 34,477

When defining a formula in the business rules editor, we can only use two entity fields:

image

So, what are we supposed to do when we have, for example, four fields to sum up (other than creating a calculated field or adding a javascript/workflow/plugin)?

image

Turns out, we can simply add multiple actions to the business rule so that every action will add one additional value to the sum field(and the first action will copy value from the first value field):

image

We also have to remember to add all those value fields to the condition just to make sure the business rule kicks in on all field changes:

image

And, once we have that, here is the end result:

image

It works.. Although, I guess it may still be easier to use javascript for thisSmile


This was originally posted here.

Comments

*This post is locked for comments