Price Value getting aggregated

[Former Member]

Hey everyone...

Here is my scenario...

I'm having a report of inventory value by material group and storage location...

Matgrp Qty Value Total

1

Material 10 3 5 15

Material 20 5 7 35

-

---

50

Instead of the total showing as 50 , I'm getting (35)*(57)= 8*12=96. for the material grp 1.

I'm not showing the materials on the report...

No, I'm not having aggregation on the CKF's as After Aggregation.

Please help me out...

any suggestions/pointers...

Thanks for your time..

/Travis

[Former Member]

hi,

Not able to get what you said but what is that written in the CKF?

Laxmi N

[Former Member]

Ok....sorry for not able to explain it better...

Here si the scenario...

I have 2 materials under a Mat grp

Material1 with qty 3 value 5/material which makes my total value @ 15 for material1

Material2 with qty 5 value 7/material which makes my total value @ 35 for material2.

When I have a report at Material Grp level

I'm getting the value as

Matgrp with qty 8 value 12 and making the total 96. which is wrong. The total shld be 50.

I'm missing a restriction somewhere or sth minor....I'm not able to figure out.....

any suggestions/pointers.

Thanks

/t

[Former Member]

One more update-----

If I throw in the material on the report.....

It calculates the value correctly...but I cant show it on the report.

Thanks

travis