5 Replies Latest reply: Jun 29, 2017 8:25 AM by Sunny Talwar RSS

    how to calculate percentage for each row

    naveen kumar

      Hi All,

                How to calculate percentage for each row i mean ,let say if data is like below

       

                      plant  xxx   yyy   zzz    vvvv

                      mah    10      20     20       40  

                       try      20       30      40      50  

       

      what i am looking is

                  

                          plant  xxx                               yyy                                          zzz                                                   vvv

                           mah   10/10+20+20+40            20/10+20+20+40                      20/10+20+20+40                               40/10+20+20+40

                            try       20/20+30+40+50            30/20+30+40+50                     40/20+30+40+50                             50/20+30+40+50

       

      so each row should have 100%

       

       

      thanks