InfoPath Dev

Hi, 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.".

I don't know what I did wrong. Would you please help me out? I appreciate any help.

The following is the xpath for the fomular:
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)

Hi alea

You cannot do Sum function on calculated value, Sum function is used for calculation on fields. You can do in the following way

Field1, Field2, Field3, Field4, Field5, Field6, Field7

Field3=Field1*Field2

Field4=Field5*Field6

Field7= Sum(Field3)+sum(Field4)

Hi, Madhuri,

Thank you very much for help. It did what I want.

Alea