How to multiply 2 fields together and put the answer in a separate field?

(0) Share

Report

Posted on by USA80

I need a way to multiply 2 fields together and then put the answer in another field. I have Field A, which consists of a drop down of Yes, No, TBD. I then have another field(B) that is a text field, but has a number in it.

If Yes is selected, then the calculation should be 1 * 100. If No, TBD or the field is blank, then the calculation should be 0 * 100. The answer should then be place in Field C

Then going on from that my next field (Field D) is a drop down with options from 1-10. I would need to get the value of the selection and times that by the value in Field E and then place the answer in Field F.

I can't do a calculated field through the Form, because of the option set. So I think I have to use a JavaScript, just not sure how to do this. Any help is appreciated. Thank you.

*This post is locked for comments

I have the same question (0)

All responses (19)

Answers (2)

Verified answer

Shaminderpal Singh 1,565 on at

Like (0)

Report

Hi ,

You can achieve this by following:

Register this function -on change of A&B

function calculatevaluesAB() {

var fieldA = Xrm.Page.getAttribute('a').getText();
var fieldB = Xrm.Page.getAttribute('b').getValue();

if (fieldA !== null && fieldB !== null) {
var calculationOfAandB = fieldA === 'yes' ? 1 * parseInt(fieldB) : 0;
Xrm.Page.getAttribute('c').setValue(calculationOfAandB);
}

}

Register this function -on change of D &E

function calculatevaluesDE() {
var fielD = Xrm.Page.getAttribute('d').getText();
var fieldE = Xrm.Page.getAttribute('e').getValue();

if (fielD !== null && fieldE !== null) {
var calculationOfDandE = parseInt(fielD) * parseInt(fieldE)
Xrm.Page.getAttribute('f').setValue(calculationOfDandF);
}
}

-Shaminder

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Is there any reason why field B is a text field? Can this not be changed to a number field so you can use it with the calculated field?

Have you also considered creating an additional field say "X" which will be used together with the other calculated field. The value in this field X will be used to save the value from field B.

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

I am open to all options. What is the best method and how can I do it?

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

I did the below but it isn't setting the answer at all.

function calculatevaluesforClaimswithcostdata()

{

var ClaimsWithCostData = Xrm.Page.getAttribute("nhs_claimswithcostdata").getText();

var ClaimsWithCostDataWeighting = Xrm.Page.getAttribute("nhs_claimswithcostdataweighting").getValue();

if (ClaimsWithCostData !== null && ClaimsWithCostDataWeighting !== null)

{

var calculationOfClaimsWithCostDataandClaimsWithCostDataWeighting = ClaimsWithCostData === 'yes' ? 1 * parseInt(ClaimsWithCostDataWeighting) : 0;

Xrm.Page.getAttribute("nhs_claimswithcostdataweight").setValue("calculationOfClaimsWithCostDataandClaimsWithCostDataWeighting");

}

}

function calculatevaluesforHowImportantis100PassThrough()

{

var HowImportantIs100PassThrough = Xrm.Page.getAttribute("nhs_howimportantis100passthrough").getText();

var HowImportantIs100PassThroughWeighting = Xrm.Page.getAttribute("nhs_howimportantis100passthroughweighting").getValue();

if (HowImportantIs100PassThrough !== null && HowImportantIs100PassThroughWeighting !== null)

{

var calculationOfHowImportantIs100PassThroughandHowImportantIs100PassThroughWeighting = parseInt("HowImportantIs100PassThrough") * parseInt("HowImportantIs100PassThroughWeighting")

Xrm.Page.getAttribute("nhs_howimportantis100passthroughweight").setValue("calculationOfHowImportantIs100PassThroughandHowImportantIs100PassThroughWeighting");

}

}

Was this reply helpful? Yes No
Shaminderpal Singh 1,565 on at

Like (0)

Report

Did you register function one on fields a , b both and function two on d,e ?

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

Yes I did

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

I am also getting an error that says, "Unable to get property 'setValue' of undefined or null reference at calculatevaluesforHowImportantis100PassThrough"

Then the next error is the same but for calculatevaluesforClaimswithcostdata

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

When I do F12, it shows that it is grabbing the values correctly, what isn't happening is the setting of the answer field. During F12 when it gets to the spot to do the calculation and set the field to the answer it shows a NaN

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

Was this reply helpful? Yes No
Shaminderpal Singh 1,565 on at

Like (0)

Report

Do you have both fields added on the form ,we usually get this error if the fields are not present on form

Was this reply helpful? Yes No