With the total weighted average of the expression

[#1]

Hello,

I have a great difficulty in making a weighted average.

the calculation is this:

= [Marginal Contribution] / [Net Income]

the total value of the expressions are:

'37256, 21 'and '79992, 00'

Where to give the total was: 46.57%

but when I put to do the calculation by the expressions gives only 26.98%

Thanks a lot for any help.

[#2]

It has some way for me to get a column total and divide by the total of the other column?

[nagaiank]

Yes. Select 'Expression total' in the Total mode' of the Expressions tab of the Properties.

A sample application is attached.

[#4]

The value of% MC had to give equal to MC% OK, I have created by putting the total value of each column.

I am very grateful for any help.

[#5]

Existe no Qlikview alguma forma de calcular a soma das linhas?

Porque a soma das linhas está certo.

[#6]

There is some form of QlikView in calculating the sum of lines?

Because the sum of the lines is right.