Dynamics CRM 2011 Calculate Ratios

Question

I've created two workflows that count the number of leads and the number of a custom entity called Legal cases. I would like to come up with a ratio for reporting purposes that calculates legal cases/leads. The workflow updates two fields on the forms (leads and cases) every time one of the entity is created. I tried to use the following code:

function calculate()

{

 var val1 = Xrm.Page.entity.attributes.get['getlead_casecounters'].getValue();

 var val2 = Xrm.Page.entity.attributes.get['getlead_leadcounter'].getValue();

     if(val1==null)return;

     if(val2==null)return;


     var result = val1 / val2;

 Xrm.Page.entity.attributes.get['getlead_casetoleadratio'].setValue(result);

}

The problem is that the casetoleadratio field doesn't appear to update. Any thoughts or recommendations?

Why don't you just do the update in the WF instead of using JS to set the value? — Andy Meyers
Hi Andy, How would you suggest using a WF to calculate the ratio between the two fields? — charlie-foxtrot117

Unknown Unknown · Accepted Answer · 2013-12-09T19:09:51

Take a look at https://stackoverflow.com/a/11923059/2295317 I think it's exactly what you are trying to do. Basically that last line should be:

Xrm.Page.getAttribute("getlead_casetoleadratio").setValue(result);

If that doesn't do it then maybe try to force a save using:

Xrm.Page.Data.Entity.Save();

as seen here: https://stackoverflow.com/a/18635688/2295317

Dynamics CRM 2011 Calculate Ratios

2 Answers