Skip to Content
0
Former Member
Mar 12, 2007 at 08:14 AM

0netprice not displaying correct values in report

70 Views

I am loading data to cube 0pur_c01 i which i have added the keyfigure 0netprice & mapped it with 0netprice infoobj ,but my report is dsiplaying the wrong results

Data for particluar material in RSA3

DocDate Tranfer Purch.Doc Material Quantity Net price

process

05.01.07 4 55036 10000051 2,040.00 78.98

05.01.07 2 55036 10000051 -2,040.00 78.98

05.01.07 2 55036 10000051 2,040.00 78.98

05.01.007 2 55036 10000051 -2,040.00 78.98

05.01.07 2 55036 10000051 2,040.00 78.98

05.01.07 2 55036 10000051 -2,040.00 78.98

05.01.07 2 55036 10000051 2,040.00 78.98

05.01.07 2 55036 10000051 -2,040.00 78.98

05.01.07 2 55036 10000051 2,040.00 78.98

05.01.07 2 55036 10000051 -2,040.00 78.98

05.01.07 2 55036 10000051 2,040.00 78.98

05.01.07 2 55036 10000051 -2,040.00 78.98

05.01.07 2 55036 10000051 2,040.00 78.98

In my report it is showing me

Qty = 2040 Netprice=

Material DocDate Quantity

10000051 05.01.07 1026.74(78.98*13) i.e there are total of 13 records in rsa3 so it is adding up and giving the sum of all netprice for this particular material

instead my report should show me

Material DocDate Quantity

10000051 05.01.07 78.98