Production Score (this is a MAX function):

Nvl((SUM({custrecord_rr_total_worktickets_complete})/nullif(SUM({custrecord_rr_analyst_goal}*{custrecord_rr_productive_hours}),0)),0)

Weighted Production Score (by productive hours) (this is a SUM function)

(RATIO_TO_REPORT(sum({custrecord_rr_productive_hours})) OVER ())*Nvl((SUM({custrecord_rr_total_worktickets_complete})/nullif(SUM({custrecord_rr_analyst_goal}*{custrecord_rr_productive_hours}),0)),0)

I'm glad I don't have to do complex SQL-esque stuff like that often!

I found that one the hard way - told someone it wasn't possible, then they had someone else come in and do it for them, and then they told me about it after the fact.

of course, just because something is possible doesn't make it prudent