Sum of product-please help

2010-09-02 Thread Nally Kaunda-Bukenya
Dear all, kindly help me with this code; This script  is supposed to calculate Rvi for each row by first summing the product of #fields (Ai*Rv) and dividing by another field (Tot) such that  Rvi=sum(Ai*Rv)/Tot. First it's acting like I need another parenthesis and it doesn't seem to work at

Re: Sum of product-please help

2010-09-02 Thread MRAB
On 02/09/2010 23:01, Nally Kaunda-Bukenya wrote: Dear all, kindly help me with this code; This script is supposed to calculate Rvi for each row by first summing the product of #fields (Ai*Rv) and dividing by another field (Tot) such that Rvi=sum(Ai*Rv)/Tot. First it's acting like I need another