Question:
Hi,
I want to define a Query with this structure:
Rows: key figures A B C D
Columns Characteristics: "type" (Values: Real/Plan).
How can I create a new Row "E" with de percentage of deviation for key figures between Real and Plan values?
With query designer I cant define total row as MIN, MAX; AVERAGE, etc but there isn`t any type for deviation.
What can I do?
Thanks in advance.
Answer:
I'm not sure to understand what you want to see ...
Can you draw an example ?
Is it like that :
KF Real Plan
A 90 100
B 50 45
C 50 50
D 200 180
What is E ? is it (90 + 50 + 50 + 200) - (100+45+50+180) ?
Is It the average deviation ?
To me, you'd better to create a third column, in which you'll have the deviation, no ?
Can you also precise your version, because maybe some 3.0 features can help you.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Query result may be like this:
Charateritics------- Real-----Plan ------[Calculated KF = %deviation]
key fig.
A ----------------------90----- 100 ------ -10%
B---------------------- 50------45 -------- 10 %
C--------------------- 50 ------50 -------- 0 %
D--------------------- 200 ----180 -------- 10 %
The column E is the calculated KF % Deviation
Answer:
How can I create a new Row "E" with de percentage of deviation for key figures between Real and Plan values?
The column E is the calculated KF % Deviation
A bit confusion don't you think???
Anyway, why don't you just create a formula?
(REAL - PLAN)/REAL*100
Cheers,
El Belgio[/quote]
Answer:
This is is the solution if i have only one key figure in columns, but key figures are in rows, and I can't create a new calculated key figure and place it in columns. key figures only can be created in rows or in columns you can't merge it, one key figure in column and other in rows, this is not posible.
I find a solution using one struture in the columns. In this structure I create two new selection creteria one filter for real an other for Plan, then created one new formula with deviation.
Thansk for for help.
I hope this solution can help other people.
bye.