Skip to Content
0
Mar 30, 2013 at 02:42 PM

Key Figure Aggregation in Bex in BW 3.5

10 Views

Hi Experts ,

I have the Following Requirement for Upgrading an existing Bex Report.

2 New Key Figures need to be created . The Key Figures are % Lines Late and % Lines Not Late .They would be displaying the % age values.

The Requirement is as :

Defect Code Group Defect Code Lines % Lines Late(NEW) % Lines Not Late (NEW )

1 A 10 (10/110)*100 100- ((10/110)*100 )

B 20 ( 20/110)*100 100- ((20/110)*100 )

Result 30

2 B 50 ( 50/110)*100 100- ((50/110)*100 )

C 10 ( 10/110)*100 100- ((10/110)*100 )

B 20 ( 20/110)*100 100- ((20/110)*100 )

Result 80

Overall Result 110

Kindly help and suggest to achieve the above .

Regards

Kamal