Skip to Content
0
Dec 01, 2008 at 11:30 PM

Sum/Count Key Figure

29 Views

I have InfoObject 0Contract, which store the Contract Number.

I have another InfoObject 0Cont_Item, which store the Contract Item number. I have also included 0Contract as Compound Key in this InfoObject 0Cont_Item.

I have Key Figure ZAmount (for Item order unit price) ,and ZQTY (for Item order QTY) assigned in InfoObject 0Cont_Item as the attributes also.

I now created a MultiProvider to join this two InfoObjects. What I try to achieve here is how can we count the total Contract Item that we have for particular

Contract and display it in the report? Example, Contract 4600000089 has Item 10, 20, 30. So the total Contract Item is 3.

Also, how can we sum the total order QTY for this contract? Example, Item 10, Order QTY = 5, Item 20 Order QTY = 6, Item 30 Order QTY = 8. So total Order QTY

= 19.

Please advice.