Getting Average problem

[syncdba]

Hi,
I have two columns
Opandate Probability Desired O/P
------------ ------------ -----------
8/1/2005 0.0 0%

9/1/2005 10
9/1/2005 20 15%
10/1/2005 10
10/1/2005 5 7.5%

I wanted Average of Probability(%) GROUP BY opendate.For that I have created a formula
Average=split(totext(Round({@avg},0)),".")[1] & "%"
& @avg =ToNumber({Command.probability}).

Now. When I go to summary & choose @Average & in "calculate this summary" I cant see AVERAGE. How can I do average of probability as in Desired o/p column.

 

[lbass]

First insert a group on {table.opendate}. Then if probability is a string, convert it to a number in {@prob}:

tonumber({command.probability})

Place this in the detail section and right click on it and insert a summary (average) on it at the group (opendate) level. This will appear in the group footer. If you want it displayed in the last detail row, then format the detail section to "underlay following section".

-LB