Hello all,
I am having a problem with my result row for a Calculated Key Figure. I am using BW3.5 Query Designer. My Query looks like this:
0CALDAY 0EMPLOYEE ZSUM_HRS HRS>8(F1)
Where F1 = (ZSUM_HRS > 8) * (ZSUM_HRS-8). Therefore if ZSUM_HRS = 12, then F1 = 4. I would always like the result to be based on 0employee. I set the calculate result as "Summation".
0EMPLOYEE ZSUM_HRS (F1)
1......................8..............0
2......................9..............1
3......................12.............4
4......................8..............0
5......................9..............1
R.....................46.............6
Now, I have a ZDEPT drilldown, where employee's belong to a department. If I add the ZDEPT drilldown, and remove the 0EMPLOYEE drilldown, my result row does not show the proper values. For example:
ZDEPT ZSUM_HRS (F1)
1.....................46.......38
(F1) = 46-8 = 36.
However, I would like the result to be equal to 6. Can I solve this problem via Exception aggregation on the base key figures that make up ZSUM_HRS?
Thanks,
Hi Gurus,
I have a similar problem as you discuss. We have a query as below which calculate C column as A/B.
A B C
C1 5 2 2,5
C2 8 4 2
C3 10 5 2
Result 23 3.36 2,09 .
The result row of A is a summation (5 +8 +10 = 23 ) .It runs OK.
The result row of B is average ( ( 245 )/3 = 3.36 ) .It runs OK.
The result row of C should be 23 / 3.36 = 6.84 . But we are not able to run it. It should not be 2.09 or another result.
Is it possible to make this calculation in the result row of C column ?
I would be gratefull.
Add a comment