0 Replies Latest reply on Jun 24, 2013 7:31 AM by Kiki Hager

    How to multiply two values and then add it up by row

    Kiki Hager

      I can't share my data as it is confidential, but essentially I want to do the following calculation on the table below:

       

      (.05*111)+(.066*61)+(.1*13)+(0.5*49)+(.66*14)+(1*224)+(1.33*39)+(2*8). The values in the secondary column will change, so it needs to update dynamically.

       

      Any help would be GREATLY appreciated!