Michel,
>>Michel
>>
>>>I'm looking for a formula. Assuming I have a rate of 1, 2, 3, 4, and 5. I then have 2 results for 3 and 2 results for 5. This would then give 4.00 as the rating result I am looking for. I'm looking for the formula which would give that rating.
>>
>>Well.. How about this:
>>
>>
>> (2 * 3) + (2 * 5) 6 + 10 16 4
>> ----------------- = ------ = -- = - = 4
>> 2 + 2 4 4 1
>>
>>
>>Does that help? I'm not a mathemetician but that's how I reckon your answer..
>
>I tried that a few minutes ago but it didn't work. Now, it does. Thanks for confirming, I guess I should have slept more than two hours last night. <s>
<g>
Probably a tpyo... <g> Just divide the sum by the total number of elements to get the average. If you need the integer abount use ROUND() function I suppose.
Have a good weekend!
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.