Skip to Content
0
Former Member
Jan 11, 2008 at 05:51 AM

Avg prices in reports

37 Views

Hi all,

We have one requirement where in we need avg value in 1 column and the sum of qty in other in other column.

For eg: we need

Material Vendor price1 price2 Qty Value1 Value2

Mat1 V1 10 15 4 10x4 15x4

Mat1 V2 10 18 7 10x7 18x4

In above report output,

Price1- this should be the average price of material based on all non zero price1 entries in cube (contains doc numbers doc item etc.)

Price2- whereas this should be the average price of material for a vendor based on all non zero price2 entries in cube (contains doc numbers doc item etc.)

qty is normal summation and Value1 and value2 are derived as shown.

Since all of them are at diffrent level i cannot use column formulas etc.

Can anybody suggest how to achieve this.

I would appreciate any help by rewarding points.

Thanks in advance.

Wrushali