Report Requirement

12 Views

Hi Friends,

I have a requirement as follows:

There are two reports : report A and its drilldown report B.

the format of report B is as below:

Note: A% is CKF calculated as TotQty / SumCT TotQty

B% is CKF calculated as DelQty / SumCT DelQty

Adher is CKF calculated as Min ( A%, B% )

RegFrom - RegTo - ContrtNo - TotQty - DelQty - A% - B% - Adher

RF1 RT1 1 100 50 25 20 20

RF1 RT1 2 300 200 75 80 75

-

Result 400 250 100 100 95

The format of Report A is

RegFrom - RegTo - TotQty - DelQty - Adher

RF1 RT1 400 250 <b>95</b>

-

Result 400 250 95

Now in Report A how can i get the value 95 for Adher.

If I use the same logic as drilldown report B then it will always give me 100.

Please let me know your views on this.

Useful tips will be rewarded accordingly.

Thanks in Advance

Shashank