Dynamics Community Forum Thread Details

Calculated Fields

I want to create a calculated field in CRM 2011

Calculated Field = Category A + Category B + Category C

The category values are as follows

Category A ['sc_categorya']
- 1 = 70
- 2 = 14

Category B ['sc_categoryb']
- 1 = 40
- 2 = 65
- 3 = 90

Category C ['sc_categoryc']
- 1 = 25
- 2 = 50

Any help would be greatly appreciated, my js file is below.

Do I need to add the OnChange event to each field?

function calculate()
{
var val1 = Xrm.Page.entity.attributes.get['sc_categorya'].getValue();
var val2 = Xrm.Page.entity.attributes.get['sc_categoryb'].getValue();
var val3 = Xrm.Page.entity.attributes.get['sc_categoryc'].getValue();

if(val1=='1') {val1 = 70;}
else if(val1=='2') {val1 = 140;}


if(val2=='1') {val2 = 40;}
else if(val2=='2') {val2 = 65;}
else if(val2=='3') {val2 = 90;}

if(val3=='1') {val3 = 25;}
else if(val3=='2') {val3 = 50;}
else if(val3=='3') {val3 = 75;}

var result = val1 + val2 + val3;
 Xrm.Page.entity.attributes.get['sc_calculatedfield'].setValue(result);
}

Quick Links

Leaderboard