Avg at expressn

[#1]

Dear All,

I have a pivot chart whr dimensionwise i had to calculate avg count percentage,

used the expression, 

avg(aggr(Count(FILE_NO)/Count(total<C_QUESTION> FILE_NO),C_QUESTION,C_STATUS

))

this works fine, see the pic

	Status	Compliance		NA		NCompliance		Total
Process	Question	%	Count	%	Count	%	Count	%	Count
Fixing	A	100%	30	-	-	-	-	100%	30
Fixing	B	100%	30	-	-	-	-	100%	30
Fixing	C	70%	21	30%	9	-	-	50%	30
Fixing	Total	90%	81	30%	9	-	-	75%	90

but the desired O/P should be,

	Status	C		NA		NC		Total
Process	Question	%	Count	%	Count	%	Count	%	Count
Fixing	A	100%	30	-	-	-	-	100%	30
Fixing	B	100%	30	-	-	-	-	100%	30
Fixing	C	70%	21	30%	9	-	-	50%	30
Fixing	Total	90%	81	10%	9	-	-	75%	90

whts happening is its not counting the misssing values, so taking avg as 30 instead of 10 %,

Please somebody let me know wht chnages to b done in the expression used, wht wrong hav i done ????

[RedSky001]

Can you provide a sample of the data prior to it being aggregated?

[#3]

hey mark,

cant do tht

[RedSky001]

Can't do it or wont do it?

If it's "wont" and the reason is the data is senative, you could always scramble the data.

It's difficult to help you without knowing what your data is.

[#5]

both !!!!!  already have a vio  la   tion on ma name, so avoiding the risk

whts scr am ble will try tht video,

thanks n respond to my post tomorrow.

[#6]

Hey Experts / Gurus,

any suggestions Pls.....