Exception Aggregation and %CT

[Former Member]

Greeting BEx Query Designer Gurus,

Does anybody know how I can get my desired results from the following data?

PeriodOrder#-Units-Work-Days-Weighted-MultiplierAvg-Days

01/20081231--5

---

7

---

0.217391304--

---

1.52173913

01/20084567--2

---

7

---

0.086956522--

---

0.608695652

01/20084568--9

---

16

---

0.391304348--

---

6.260869565

01/20087890--7

---

19

---

0.304347826--

---

5.782608696

Result--

---

23

---

49

---

1--

---

14.17391304

02/20084892--9

---

12

---

0.5625--

---

6.75

02/20085752--7

---

8

---

0.4375--

---

3.5

Result--

---

16

---

20

---

1--

---

10.25

In the above data, I am only interested in the Results for the Period Drilldown only row and the Average Days column. So only the 01/2008 14.1739... and 02/2008 10.25

The Weighted Multiplier is %CT ( Percentage Share of Result ) Units / 100. The Avg Days = Work days * Weighted Multiplier.

Problem is, when I take the Order # out of the columns, the Weighted Multiplier is no longer percent share of the Result, as the Result is now the total based on the Period.

I tried to make the Weighted Multiplier with Exception Aggregation Total, with Ref. Char = Order #, still no luck.

Any Ideas will be greatly appreciated....

Kind Regards,

Alex

[Former Member · Accepted solution]

This might be caused because I believe Unit and Work Days are attributes of Order.

Are you using structures?

And did you to get the results by hiding the Order, Unit, Work Days and weighted multiplier columns?

[Former Member · Accepted solution]

Hi Abhijit,

Unit and Work days are not master data, rather transaction data.

I am just using the main Key Figure Structure, nothing more.

If I hide "no-display" the order, and "hide" the other key figures, I still get the long undesired list, its just now displaying the Period in multiple Rows and DIVISION BY ZERO in the results. When I put a NODIV in the formula, the result is 0.

Regards,

Alex