Weighted Average

[morechocolate]

I am using the weighted average function in Crystal and I cam not getting the result I was expecting. When I derive the formula, based on how I believe the weighted average is calculated, I do get the desired result.

Data sample:

Return Par
1.13 531,401.20
1.26 5,000,000.00
0.00 0.00

Using the weighted average summary function the result is .46. The same holds true if I used the weighted average summary in a formula. That formula is:
WeightedAverage ({RETURN},{PAR},{GRP2})

If I do the following:

(1) col1 * col2
(2) sum of (1)/sum col2 the result is 1.24, the desired result

Any ideas on what I may be doing wrong.

Thanks

mc

 

[synapsevampire]

There are known bugs, what version of Crystal?

http://support.businessobjects.com/library/kbase/articles/c2011241.asp

-k

 

[morechocolate]

Thanks k,

Actually, I found that article after I posted the message. I should have checked businessobjects first.

I have an inquiry with our IT folks to see if they can apply the service pack for me. It is as current as Jan 2004.

BTW - I am using Crystal 8.5.

Thanks again

mc