Skip to Content
0
Former Member
Jun 10, 2011 at 07:23 AM

Query Designer: Calculate a % based on two other totals

47 Views

Hi Gurus,

Here is the scenario of my query:

A B C D E

2 3 6 4 150%

1 2 2 4 50%

2 2 4 8 50%

1 1 1 10 10%

-


6 8 13 26 50%

Column C is calulated by AB and I am able to get the total 13 instead of 48 (68) by using the "Total" calculation function.

The problem is about the Total of Column E. It is a % based on columns C versus D. There's no problem for individual results, but for the total I cannot get the 50% because my query calculates the total result comparing 48 (6*8) Vs 26.

If I also use the Total function for the E Column, what it shows is an addition of all the individual results, so 260%.

I can't find the way to get the Total 50% that takes the "Total" function of Column C and Column D.

Please, any idea so solve this scenario?

Many thanks!!

Regards,

Jordi