x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 9 replies
  • Subscribers 75 subscribers
  • Views 1726 views
  • Users 0 members are here
Browse Forums
Announcements
106
topics
32
replies
General Discussion
6k
topics
18k
replies
Jenely88

calculating fields

Posted By

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);

Reply
  • 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);

Children

*Community Hub is the new name for Sage City