https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/4216.aspxMon, 12 Mar 2007 15:08:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4216alea0https://www.infopathdev.com:443/forums/thread/4216.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=4216Hi, Madhuri, <br /><br />Thank you very much for help. It did what I want. <br /><br />Aleahttps://www.infopathdev.com:443/forums/thread/4215.aspxMon, 12 Mar 2007 07:34:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4215madhuri0https://www.infopathdev.com:443/forums/thread/4215.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=4215Hi alea <br /> <br />You cannot do Sum function on calculated value, Sum function is used for calculation on fields. You can do in the following way <br /> <br />Field1, Field2, Field3, Field4, Field5, Field6, Field7 <br /> <br />Field3=Field1*Field2 <br /> <br />Field4=Field5*Field6 <br /> <br />Field7= Sum(Field3)+sum(Field4)https://www.infopathdev.com:443/forums/thread/1904.aspxFri, 09 Mar 2007 21:08:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1904alea0https://www.infopathdev.com:443/forums/thread/1904.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1904Hi, I am trying to calculate final ratings. and What I wanted is something like sum(rating * percentFocus) + sum(rating * percentFocus) + sum(rating * percentFocus) + sum(rating * percentFocus) + sum(superRating * percentFocus) and I got the error "Argument 1 must return a node-set.". <br /><br />I don't know what I did wrong. Would you please help me out? I appreciate any help. <br /><br />The following is the xpath for the fomular:<br />sum(../../my:core/my:customerFocus/my:managerEvaluation/my:rating * ../../my:core/my:customerFocus/my:percentFocus) + sum(../../my:core/my:collaboration/my:managerEvaluation/my:rating * ../../my:core/my:collaboration/my:percentFocus) + sum(../../my:core/my:leadership/my:managerEvaluation/my:rating * ../../my:core/my:leadership/my:percentFocus) + sum(../../my:results/my:result/my:managerEvaluation/my:rating) + sum(../../perf:currentObjectives/perf:objective/my:supervisor/my:superRating * ../../perf:currentObjectives/perf:objective/perf:percentFocus)