I would like to create an opportunity report list that provides a summary of forecasted totals discounted by the probability assigned to each opportunity -(probability * total) evaluated as a mathmatical expression. I then want to total the calculated result for subgroups (assignedto) and as a grand total for the whole report.

From this report I will be able to determine the likely value of each sales reps opportunity pipeline by opportunity and in aggregate.

I have tried fooling around with F-Script to summarize the calculated result but no luck. If anyone has a similar report or can post some workable code I would appreciate it. Thanks