cancel
Showing results for 
Search instead for 
Did you mean: 

Values Not being calculated in the query

Former Member
0 Kudos

Hi:

I have a customer with contract from 01/01/2006 to 12/31/2006 for the same material.

Material Qty Price

A 25000 19

A 15000 18

In a report the query shows

Material Qty Price

A 40000 37

I need to find out Why its not showing me weighted average price of 18.625 instead of 37 which is not correct.

Any Idea?

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Take a look at the following thread:

https://forums.sdn.sap.com/click.jspa?searchID=6542904&messageID=3984947

Hope this helps...

Marco

Former Member
0 Kudos

Hi Bhanu:

I changed the setting but still having a issue.

Material Qty Revenue Net Price (Formula)

A 25000 475000 19

A 15000 270000 18

When I run a report the resultas rea as below

MAterial Qty Net Price

A 40000 37

Shouldn't it be (475000270000)/(1500025000) = 18.625

I am confused.

In formula collison What value I should pickup?

Thanks

Former Member
0 Kudos

Hi:

I created a formula where I'm dividing total revenue by qty. According to the formula. I should get 18.625 and not 37.

Is there something I have to fix in the formula?

former_member188975
Active Contributor
0 Kudos

Hi Sunil,

Please check the forumla collision setting in the formula properties.

Check this link:

http://help.sap.com/saphelp_nw04/helpdata/en/d2/02223c5f00612be10000000a11402f/content.htm

Hope this helps...

0 Kudos

hi,

check the properties of that kf, calculate result as, set to 'average' ? hope this helps.

former_member188975
Active Contributor
0 Kudos

Hi Sunil,

In your query, right click the Price KF and choose properties. What does it mention in Calculate Results As?

Former Member
0 Kudos

Hi Bhanu:

It Says Nothing Defined.