cancel
Showing results for 
Search instead for 
Did you mean: 

Number of Purchase orders for a Purchase Group

former_member182343
Active Contributor
0 Kudos

HI Experts,

I went through this doc.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/009819ab-c96e-2910-bbb2-c85f7bdec...

I have POs and Purchase Group and with many Purchasing Feilds.

i want to get Count of POs in a specific Purchase Group.

Issue:

PO---- Pur Group---- PO value

45001198--010--- 100

45001198--010--- 100

45001198--010--- 100

I want to display the data as

PO- Pur Group--Count( No of POs)

45001198--010--- 1

But I am getting as

PO---- Pur Group--- Count( No of POs)

45001198--010-3

I have created Formulae var with Replacement path with below steps

Replacement Path tab

Replace variable with - infoobject

Replace with -


variable

Attribute - charecterstc reference(constant 1)

Calculation- After Aggregation

Can any one suggest how to achieve my objective.

Regards,

rvc

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello RVC,

if you want just to know how many row to you have in this report, you could set a formula with a constant (=1).

Each row will be count as 1 and you can have a sum of the rows.

If you relate a formula to an InfoObject, the count is made by this InfoObject in the report and the result, as per your example, will be 3.

Hope it helps.

Best regards.

Simone.

Answers (2)

Answers (2)

anshu_lilhori
Active Contributor
0 Kudos

Hi,

PO---- Pur Group---- PO value
45001198----010----- 100
45001198----010----- 100
45001198----010----- 100

First question how you are getting this data as i cannot see unique set of values.

You have already referred the the pDF and hopefully done the proper selection of infoobject.

Read this:

Why Calculated Key figure instead of New Formula?

Reference: help.sap.com

The replacement of formula variables with the processing type Replacement Path acts differently in calculated key figures and formulas:

If you use a formula variable with u201CReplacement from the Value of an Attributeu201D in a calculated key figure, then the system automatically adds the drilldown according to the reference characteristic for the attribute. The system then evaluates the variables for each characteristic value for the reference characteristic. Afterwards, the calculated key figure is calculated and, subsequently, all of the other operations are executed, meaning all additional, calculated key figures, aggregations, and formulas. The system only calculates the operators, which are assembled in the calculated key figure itself, before the aggregation using the reference characteristic.

If you use a formula variable with Replacement from the Value of an Attribute in a formula element, then the variable is only calculated if the reference characteristic is uniquely specified in the respective row, column, or in the filter.

Hope it helps.

Regards,

AL

sven_mader2
Active Contributor
0 Kudos

Hi,

do you use a multiprovider for your reporting - and you have more than one infocube?

=> the formula variable works only for one infocube.

Why you don't use the keyfigure from the datasource 2LIS_02_HDR?

Sven

former_member182343
Active Contributor
0 Kudos

HI Mader,

I am reporting on IC.

Do you mean about NOHDR . I hope it will not satisfy my requirement.

Can any other solutions.

Regards,

rvc