calculating fields

This question is not answered

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

 

 

All Replies
  • it might be easier using a derived field and doing the calculation in a view or updating the field via an escalation rule or a table script

    community.sagecrm.com/.../adding-derived-fields-in-views-into-meta-data.aspx

  • did you miss out the character ";" at the end of the statement ? was it an expected error or something else?

     

    Kannan Srinivasan

  • Thanks i am going to look into this

  • i have tried it with and without its still not working. Thanks

  • i found another method of doing it however it only works for adding up two fields! if i use

    oppo_sostotal.value=(parseFloat(oppo_sospain.value)+parseFloat(oppo_sospower.value)).toFixed(2)

    this adds those two fields up into the thrid. i have tried adding more fields to this code but it doesnt work so not sure.  i.e

    oppo_sostotal.value=(parseFloat(oppo_soscollaboration.value)+parseFloat(oppo_soscrta.value)+parseFloat(oppo_sosvalue.value)+parseFloat(oppo_sosvision.value)+parseFloat(oppo_sospain.value)+parseFloat(oppo_sospowervalue)).toFixed(2)