1 Reply Latest reply: Dec 15, 2014 4:15 AM by Gysbert Wassenaar RSS

    how to calculation total % after sum() in straight table


      Hi guys

       

      there is a table like this

      a   b     c

      1   100  1000

      2   200   2500

      3   300   3000

      ...

      and then, i need to get a table like this

      a   b    c         d

      1  100  1000   0.1(100/1000)

      2  300   3500  0.085(300/3500)

      3....

      ...

       

      i used the straight table ,in the expression

      b and c column, i used  full accumulation,

       

      but i can not get d column with correct data.

      i used [b] /[c] in d Column.

      but it will get this data as below:

       

      1 100 1000 0.1 (100/1000)

      2 300 3500 0.08 (200/2500)

       

      so how can i get the correct data.

      Please help me ,thanks very much!!