calculating fields

I have searched through the forums and found a few posts regarding calculating fields, I have tried these and cannot seem to make them work for me!

I have 6 fields which I need to add up and the total displayed in the 7th field. Should this work:


oppo_c_sostotal
.value
=oppo_c_strengthofsalecollabora+oppo_c_strengthofsalecrta+oppo_c_strengthofsalepower+oppo_c_strengthofsalepain+oppo_c_strengthofsalevision+oppo_c_strengthofsalevalue

It does not seem to work for me....is there something obvious i am doing wrong??

Thanks

Parents
  • 0

    Thanks everyone! I have finally managed to get it to work using the following:

    var oppo_soscollaboration = crm.fields('oppo_soscollaboration').value();

    var oppo_soscrta = crm.fields('oppo_soscrta').value();

    var oppo_sosvalue = crm.fields('oppo_sosvalue').value();

    var oppo_sosvision = crm.fields('oppo_sosvision').value();

    var oppo_sospain = crm.fields('oppo_sospain').value();

    var oppo_sospower = crm.fields('oppo_sospower').value();

    var thetotal = parseFloat(oppo_soscollaboration) + parseFloat(oppo_soscrta) + parseFloat(oppo_sosvalue) + parseFloat(oppo_sosvision) + parseFloat(oppo_sospain) + parseFloat(oppo_sospower);

    crm.fields('oppo_sostotal').value(thetotal);

  • 0 in reply to Jenely88

    Does this script get placed in the custom content of the screen or on the create script of the fields involved.

    Trying to determine why I cannot get some calculated fields to work.  Thanks!

  • 0 in reply to Michele Gaw

    This looks like it is using the Client Side API.  So this will have been placed in either the Custom Content (or in a file included in Custom Content) or an onChange() script.

Reply Children
No Data