Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 /
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!!
Try rangesum(above(sum(b),0, RowNo()))/rangesum(above(sum(c),0, RowNo()))
See attached qvw.