Need help for expression

[#1]

Hi I have this pivot table after final manipulation

ITEM CODE	QUANTITY	PRICE
1501	2	0
1502	1	0
1501	2	1000
1502	5	100

i have to achive this

ITEM CODE	FOC Q	QUANTITY	PRICE	AVG PRICE
1501	2	2	1000	250
1502	1	5	100	16.67

please tell me the exprssion used for

FOC Q

QUANTITY

PRICE

AVG PRICE

[vijay_iitkgp]

Hi Pramod,

You can achieve this by:

FOC Q= Sum(If(Price=0,Quantity));

Quantity=Sum(If(Price<>0,Quantity));

Price=Sum(Price);

Avg=Sum(Price)/Sum(Quantity)